This doesn't require single family housing on giant lots. Just well built buildings with proper insulation and sound proofing. I used to think apartments were just noisy until my partner and I moved into our current place. I live on the top floor of a 2 building, 6 unit complex of loft apartments cascading down the side of a hill. The buildings had to be built to withstand the extremely strong winds from the bay, and as such they're solid as fuck.
Despite our downstairs being tile floor our neighbors have told us they haven't heard any noise from us at all. My partner and I started being less concerned about noise and began playing somewhat loud music frequently and yell to each other across the unit. Despite this our downstairs neighbors still haven't heard a peep from us. For a while I genuinely thought our neighbors were just trying to be nice as everyone in our complex is super friendly and gets along well.
One day our neighbor in the adjacent building was woodworking in his garage. Normally the noise wouldn't bother me, but I was focused on something so I shut the window facing the courtyard which made me realize just how soundproof this giant concrete building is, both between units and to the outside world. I couldn't hear our neighbors saw unless I opened the curtains and tried to hear it, otherwise it might as well have been very faint background noise. I really wish buildings like this were the norm for apartments because they provide all the privacy of a single family home with all the benefits of apartment buildings.