It's entirely possible. My friend told that his almost newly built apartment had very good insulation. My parents is good as well, only noise really is the elevator if on other side of wall. My current rental isn't bad either. Though some noise get through. Last place was horrible though, specially with dog that made noises through the night...

So it is possible to have good noise insulation. In general the noise from outside is bigger problem than from neighbours. Only real case with issue is renovation as any drilling or hammering through travel in structures.