Come on, no one hear who said 999 ? It's one of the best ending i could see these last years.
And a few others games :
Valkyrie profile (with the best ending, i really liked it)
Metal gear solid 3 (i don't even need to say why) and same for the 4.
Danganronpa 2, totally didn't expected this ending/last chapter.
And probably others.