Portal 2- Absolutely love this ending. Best ending ever.
To The Moon- A great bittersweet ending. :(
Bioshock Infinite- I only like this game because of that ending.
Shadow Of The Colossus- :'(
Chrono Trigger- Cheesy but awesome.
There are more but these are the one that I can think of right now.