I think MGS3 probably had the ending with the biggest impact for me. Yes it was very predictable but the way it was handled with forcing the player to do the dirty deed and then Eva's monologue designed to make you feel as bad as Big Boss was feeling made the whole sequence brilliant.

I feel Journey had a pretty powerful ending as well especially due to the game's brilliant build-up towards it in the snowy mountains.