Lufia 2 was pretty cool because the ending sequence was the beginning sequence of the first game.

Here's an old school one: Kid Icarus. That final stage where you don all the treasures and turn yourself into a powerhouse to face Medusa was one of the coolest final moments of a game when I was a kid.