How does a detached single family home prevent honking? Why haven't you explained to my neighbors they have to stop honking? Because they definitely still do, and it is still a nuisance
Detached homes definitely have many benefits, but they're incredibly expensive. If we didn't subsidize them so much, we'd have a whole lot more people living in denser housing. The US has something like 85% single family homes compared to around 40% in Germany
It's not that Germans are just so much better neighbors that they can put up with shared walls/spaces. It's just not worth the cost of a detached home when it isn't as heavily subsidized (they do still subsidize them compared to dense housing options)
TL;DR - Detached homes are fine, but we need to quit giving such massive subsidizes to them
Homes don't generate value though. Nothing more is being created by them existing. How can it possibly be an investment generating more wealth when the underlying asset remains unchanged?
It's just a pyramid scheme to expect the same exact home to continue going up in value as an investment. The only possible result is a shortage of housing with unreasonably high prices