If you really want to cry at a movie, try watching Children of Men. That one will ravage your emotions.

I got a bit choked up at the ending to Big Fish, also. That's still a really great movie.