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.
That's not at all in the league of the 1-3 millions inhabitants cities you quoted. Paris is a nightmare to live in and people want to flea from it. There used to be close to 3 millions inhabitants and it is now down to slightly over 2 millions.
The population density is basically identical between these areas, but I can't imagine why anyone would want to live in a low-rise area.
(Incidentally, the reason we have low-rise areas is because the city has an absurdly long list of "sight cones" to protect views of the local mountains.)
Personally, I find the 5-8 story setups of cities like Paris, Barcelona or Rome much more appealing - enough density to make all the good things like walkability and local cafes happen, but no blocked out sun (Like in NYC) or need to climb to 20th floor when the elevator gives out for the nth time.