When Edmonton's City Centre Airport(YXD) was open to scheduled air service by AC's and CP's regionals and Canadian and Canadian North (a northern subsidiary which operates 737-200 Combis) before 1995, 732s and Fokker F28s often roared overhead, sometimes making my apartment windows rattle! I live right under the flight path into one of its runways, BTW.
YXD is only a few kilometres north of downtown Edmonton, and is surrounded by a lot of resdiential space. Not surprisingly, Edmontonians had been complaining about the noise generated by the 737s and F28s that came in and out.
In October 1995, a referendum closed the airport to all scheduled service except for planes with 12 seats or less. The major reason was that people were concerned that Edmonton was losing airline service to Calgary because Edmonton had two airports, and the International (YEG) was slowly dying, as airlines were increasingly using Edmonton as a feeder spoke rather than a direct destination into YEG. Noise was also part of the reason, though.
Although YEG is pretty close to Leduc, a city of about 17,000, I haven't heard much in the way of complaints about noise, mainly because the runways are aligned in a way that the noise footprints are mostly to the north and over the south end of the city.
While Vancouver International (YVR) sits on an island, there are some residential areas that sit a bit close to YVR in Richmond, BC. My brother lives in an apartment very close to one of the flight paths, and you can sometimes see 747s and other planes close enough to make out the airline's names on their fuselages or the tail designs coming almost overhead. Yet, there is not that much noise and only once in a while do you really hear anything. So, my brother doesn't have any problems noise-wise where he lives. It is only when you are really close to the Fraser River and the island on which YVR sits do you really begin to hear a lot of the noise from a/c takeoffs and landings.