for me, i personally find that the construction of the apartment matters a lot more than how noisy my neighbors are; I moved from a duplex in a very quiet neighborhood in sunnyvale to an apartment right under the SJC flight path, but the old place was last updated in the '60s and had single-pane windows, while the new place was built in the '80s and upgraded pretty significantly in the aughts. It is rare that I hear noises loud enough to notice over a running fan or air purifier when the windows are all buttoned up.

Double/triple pane windows make a huge difference (as does offset studs drywall standoffs)