I like the idea of 5-6 story buildings and know we need higher density housing, but past experiences make we want to live in a 2-story (semi-)detached house with enough garden to keep the neighbours at a distance.
But apartments made since 2000 have had excellent sound-proofing. Absolutely silent from neighbors. Only reason not to live in a new flat with walking distance from services is if you really like gardening.
Early modern housing schemes (of which Berlin has quite a few really interesting examples, e.g. the Siemensstadt developments to the north of Siemensdamm subway stop) were a great response to how those traditional patterns sufferered from overcrowding back when they supported much higher density than today. Unfortunately, that style developed into something very ugly when it was ruthlessly scaled vertically a few decades later.