The Green Mile
The only film that's ever brought a tear to my eye. It's amazing how much the soundtrack evokes emotions in you, if you turn off the sound that scene doesn't affect you at all. Brilliant film.
.......oh and.....Star Trek II....when a certain main character dies, that always manages to choke me up a bit (no tears though! I'm not that much of a geek, lol).