I get a bit teary at most chick flicks, but thats because I'm a very sensitive guy, haha!
The only film that truly made me cry because it evoked deep sadness was the film Philadelphia. I had just recently lost one of my best friends in college to AIDS, and this movie pushed all the water faucet buttons in me. I was a gushing firehydrant at the end.
There's been a couple that get me pretty choked up - no matter how many times I see it. As previously mentioned - "The Green Mile" is the main one... but "Saving Private Ryan" gets me too. Other ones that I've gotten pretty bad about would include the very last scene in "The Shawshank Redemption" and some parts on "Fools Rush In".
It's kinda funny how two of those movies were written by a horror writer - Stephen King. LOL