When you save a random boy's life by giving CPR in Fahreinheit it gave me a powerful feeling, and I think that's a good example of how it doesn't need to be a huge climatic ending for you to get emotional it can be a tiny 5 minute side-quest like saving the random boy.
Grim Fandango ending I second the tears in my eyes, I was really trying not to cry since my parents was in the room and it was embarrasing to cry