The ending of Mahler 2nd, tears of joy every single time, provided I have listened (or played) through the whole symphony. Get's me every time, whether listening or on stage.
And for sadness, the end of La Boheme when Mimi dies:
I also worked on an amazing production of The Hunchback of Notre Dame a few years ago, and the ending of that got me and several other band members sometimes, even after more than 50 shows - but that was more to do with the cast being so damn good than the music itself, I think...I've never listened to it since, but there was just something about that production that clicked and made an emotional experience almost every night.