I used to live right by Deerfoot and 64th Ave...so had Deerfoot, the airport, and the train tracks out our window. It was loud at first, but after a few months I didn't even notice they were there. I imagine random noises like an ambulance are a bit tougher than repetitive noises, but your brain definitely adjusts.
The Woo girls and motorbikes in the Beltline were way more disruptive.