I cried when I watched the "Battle of Los Angeles" (also tears of pain) but it was that bad . I'm not sure any other video has a lower rating then 1.9 on IMDB.
Some anime dramas will get a tear out of me.
I know it's just a crummy movie/U.S. Marines rah-rah fest, but a part of me took a guilty pleasure in watching that movie.
Edit: Whoops, I guess that's a different movie. I was thinking of Battle: Los Angeles
---
I don't think I've ever cried from just a movie, but a few have come close. Besides Toy Story 3, the ending to Friday Night Lights almost did it.