I'm sure it depends on demographic/country etc, but I've lived in Apartments where everyone was considerate, no loud neighbours, no smokers. Everyone just peacefully co-existed. (I've also experienced the opposite, and unfortunately, it is more common.)

And I've lived in apartments designed to be much more sound proof, then the neighbors could do whatever they wanted and didn't have tip-toe around each other.

All it takes is one good neighbor moving out and a bad one moving in next door…