Some of the best video game endings...
Guitar Hero III: Legends of Rock is definitely one of them.
Guitar Hero: Smash Hits/Greatest Hits(PAL) also has a great ending.
Guitar Hero: Warriors of Rock has a good ending.
Guitar Hero I also has a great ending.
The ending of Guitar Hero: World Tour is more like the beginning (you'd have to view the movie to get it).
Spy Hunter for PS2 has a few great endings (though I'm not quite sure wheat those red beams are that envelop the world when you lose).
Tony Hawks' American Wasteland has a good ending (and fun to watch).
The original ending video for Hammerhead's Victory in Twisted Metal I (these videos were canned because they were of poor quality) is good too.
The end of Midnight Club 2 is good; the ending of Midnight Club 3: Dub Edition is even better.
I like the end credits for both Lumines and Lumines Plus.
The end movie for Medal of Honor (Play Station) is good; getting the Medal of Valor (100% completion) is even better.
I also like certain ending types.
Like, whenever you finish a song in any Guitar Hero game, the fretboard/highway explodes or vanishes with the appropriate SFX, and the words 'You Rock!' display on the screen. The sequence itself differs from game to game (with exception to GHI, GH2 and Rocks The 80s where it is the same), but my faves are GHIII, GH Aerosmith, GHWT, GHSH, and GHM.
GHIII is like a metal riff that sounds like it is saying 'You Roooooooooock!', and Aerosmith is basically the same, only afterwards the letters explode and fall off the screen, accompanied by an appropriate (and awesome) explosion SFX.
GHWT sounds a bit different, and two fingers shoot lightning at the letters before they explode and fall off the screen (the exploding letters became a staple part of the sequence as of Aerosmith). Also, in GHWT and games beyond, the words 'You Rock!' were translated into the language of the game, such as saying 'Que caña!' in Spanish.
GHSH has a plaque that comes up with the words, and then it vanishes after being electrified, but doesn't explode (only the main games do they explode).
GH Metallica has the St. Anger fist (it's red and has binding ropes around it) punch upward into the screen, and then when the fist retreats, the words 'YOU ROCK!' appear. The background sound effects accompanying this one are awesome, but since this is Metallica, you shouldn't expect any less.
I also like victory music. A lot of Final Fantasy games have Victory Music that makes me feel good.
There are airship themes I like too.
In my RPG Maker game, I plan to use a lot of outside-the-developer music and sounds, including an excerpt of Druox the Shredder's Console War, as the theme for when the character that becomes a force to be reckoned with, becomes fully invulnerable in battle. (Prepare your ears for a barrage of incredibly loud speed metal)
I love soppy, sappy and romantic endings. I love it when the heroes win, and restore balance. Of course, I also respect those who wish to end things badly, especially when the story builds up to it; I get the logic of not switching it up to where things suddenly end well. Like wtf was that. I remember the story of the Little Mermaid by Hans Christiansen. According to him, the main character of the story (I believe her name is Serena), decides to dive into the ocean and drown herself. I respect that because that would be a more realistic ending than Disney's version.
I've written stories that end badly myself, if only to explore the emotional rapture that follows, and try to make it realistic. It's not easy, but I've done it a few times without straying too far off course.
