There's nothing farcical about wanting one's own space where there's space to have one's own space. I'm grateful to no longer be sharing walls with a domestic abuse couple on one side and a midnight banshee on the other wall when she got busy. Energy is cheap, people are exhausting.

And that gets into another coordination problem we're unable to solve. It's a solved problem to build apartments where you can't hear your neighbors, but the builders don't have incentive to spend the money upfront to do so and we add regulations to make it more expensive for them to do so. So people go on thinking "apartments suck" and not the correct "we shouldn't let people build apartments which suck".

Also, living in SFH isn't avoiding all problems. I'd rather live in a properly-built apartment than my old house when my neighbor left her dogs outside to bark for the entire work day, every single day, and all the city would do is fine her a hundred bucks every few months. (or if you want to say "rural", that's 1 a small fraction of the population and 2 I like hospitals).