Different strokes for different folks. I’m a very happy single family home dweller. Living in a dense city feels claustrophobic.
The Anglosphere is more car dependent and more prone to NIMBY policies and housing shortages than continental Europe, because continental Europeans are more comfortable with density. Density is the solution to many land management problems.
The noise problem isn't limited to loud music and parties, just the noise of kids playing loudly and running around in communal areas can become infuriating to neighbours.
Even if you've got good neighbours, there's other downsides with flats - a lack of parking/EV charging, often nowhere to safely store a bicycle even. No space to install personal 'green tech' such as solar or a heat pump. No garage/shed to store tools/bikes/hobby equipment.