I'm living in a German city near (but not directly on) a busy street (as in: lots of cars and tram service every 5 minutes on workdays and every 30 minutes at night). Trams are about as loud as cars, but there are fewer trams than cars, so cars rank slightly worse than trams for me.
The only mode of transportation that's "practically silent" is bicycles. (Pedestrians are silent, too, except for those drunk idiots who like to loudly argue before my house at night.)
> Buses, trucks, trains, and motorcycles all make drastically more noise.
Motorcycles are THE WORST.
> Especially when the buses are operating their airbrakes and audible announcements,
WTF? Announcements happen inside the bus, not outside. (Except if there is a blind person on the platform. They have devices that make the tram or bus announce its destination. But blind people are exceptionally rare, especially at night.)
> trains are blowing their horns as they crawl away from stations
WTF? I only ever see trains blowing their horns when approaching one of the few ungated level crossings in the countryside which have not been outfitted with gates yet.