Man, there's a few.
Stallone really gets a lot of shit for Rambo, but "First Blood" fucked up my dad bad. When I watched several years later, and especially after being in the service, I understood why. My dad lived that shit for two years. Seeing his buddies shot up, shit blowing up in the jungles/rivers, incredible. Apocalypse Now is right there as well.
As for me, heh. I get cheesy sometime. Sure, call me gay, but the ending between Willis/Tyler/Affleck in Armageddon made me bawl like a newborn. I got all wrapped up in seeing Will Patton and gang coming off the shuttle, kid holding the fucking radio, flags swaying side to side like big mama at a church revival. Holy shit.
Poltergeist. Everybody talks about "They're Here" and little Carol Anne and all that good shit, but the clown.. Man, the fucking clown. Between that and Pennywise, shit. Clowns get the finger every time, for all time.
SneakyPete, I'm with you on Gump. To see a *ahem* tard accomplish so much, only to be denied the one thing he ever wanted, man, that gets me.
Being a minority, Daniel Quinn's "After Dachau" really got to me. It's not a terribly long book, but a lot of it made me think of how different my life would have been had the Nazi's won WWII (of course, arguing that I would even exist).
300 made me want to burn down the entire state of South Carolina for about an hour after I watched it. Fortunately, the Awful Waffle took care of that for me.
I could go on and on, to be honest. Thank God for the written word, as well as film.