It’s nearly as if there’s no single solution. Houses suck and apartments suck for completely different reasons.

(But tbh, nearly all of the reasons you mentioned apartments suck have been maybe an issue once 10+ years of living in apartments)