Music is to me a very emotional experience, so I freely admit that it makes me teary when listening to many types of music. Sometimes it's the music, sometimes it's the memory associated with the music...
I think the only time I've cried onstage was the premiere of my first symphony, at the musical climax of the second movement. I had written the music as a "story" just for the purpose of composition, but the work is not really "program music". When we were playing, my mind drifted to the story I had written and it made my cry. LOL I'm such a sucker.
One of my favorite musical moments, though not a tearful one, is Grofι's
Grand Canyon Suite, movement 4, "Sunset" - the last 40 or so measures always instill me with a wonderful sense of calmness.