Most Grasshopper games but also add Silver Case as I just finished the remake. What a ride.
As was said I also enjoyed Portal 2.
Deadly Premonition is another one. The sort of epilogue was neat, reminded me of the Oracle Zelda games letting you explore after finishing them and seeing the effects of how you helped out.
Speaking of, the endings of a lot of Zelda games are cool. LA, OoT, MM, TWW, SS.
GTA San Andreas and 4 have their moments but Red Dead Redemption has to have the best Rockstar ending.
Mgs1 , 2, 3, even some parts of 4. 1 of course being the non canon ending for me. Not that I don't like Meryl but I like seeing Snake and Otacon more and feel the hopeful ending is a bit out of place, just doesn't sit right with me.
Then there are just endings I hate...MGSV, GTAV, Saints Row 3/4, all David Cage games, Metroid: Other M, etc. Granted I hate all these stories as a whole except Metroid.
_________________
About suffering they were never wrong,
The Old Masters: how well they understood
Its human position; how it takes place
While someone else is eating or opening a window or
just walking dully along...