I feel like something that nimby's fail to also understand when it comes to the missing middle housing is that it doesnt even have to look like mid or low rises and thick apartment blocks. For example if you look at the more populated parts of buffalo NY there are apartments spread out here and there but a good chunk of the housing is houses with lawns on good looking tree lined streets.
Now these houses are close together, in some districts they dont even have a driveway(or its barely wide enough between houses for a car to get through), but theyre still nice looking 19th to early 20th century houses with nice wood work and detail. Many of these houses are also stealthily multifamily homes. A lot of these houses were built with an upstairs and downstairs unit in mind.
So you have neighborhoods that could fit the criteria and look "suburban" but are secretly more dense than expected. And thats the big issue with the housing crisis. Its not that central downtown areas dont have enough towers, or that single family homes exist in major cites, it's that as soon as you get into an inner suburb the density falls to like 2,000 to 4,000 per square mile. You could still have nice houses, trees, parks, and be detached and have driveways and still maintain an easy density of 10,000-16,000 within walking distance of a nice little main street.
Think of how de-congested the housing market in NYC would be if there were little cities around it(besides yonkers and NJ side of the river). If Nassau county and westchester didnt immediately drop off a cliff densitywise? Again it could still be full of trees and parks and golf courses and grass lined streets, and detatched houses, but it would just be plotted a little closer together and have a slightly more urban flair to it.