Heavy Rain was sad the whole way through.
Gears of War was quite depressing with the whole world getting fucked over but not really sad. Same goes for Reach.
I've never really been incredibly moved by any game.
As for movie goes, I cry everytime I watch the Lion King, and almost every other Disney movie.