Remember, tears can be from sadness or joy. (vague spoilers ahead)
Shawshank Redemption (tears were streaming leading up to the end)
12 Angry Men (When Juror #3 tears up the picture and realizes the error of his ways. This movie must be seen before you die. The ending is extremely eye-opening.)
Etneral Sunshine of the Spotless Mind - for whatever reason, I cried really hard during this exchange "But I know I'm going to get bored of you." "... Ok"
Homeward Bound (the music that plays when Shadow comes over the hill. I was eight.)
The Black Cauldron (SPOILERS!!!* This is the most underrated Disney movie ever and you've probably never seen it or heard of it.)
*When Taron holds Gurgie's seemingly lifeless body and that damn music plays. The freaking lovable little critter sacrifices himself because he, "has no friends."
Honorable Mention: Terminator 2 - never has a thumbs up meaned so much. Still my favorite movie of all time. Oh, and don't forget any Holocaust movie (had to watch The Grey Zone back in college and students were weaping).