Pick a tune from Halo: Combat Evolved. They're all good. Yes, even that one. They're all fantastic. You have bad taste in music if you don't like them all

Though, if I must pick one: "Rock Anthem For Saving The World".
Most tunes from Super Metroid are quite good... though I don't care for the Miridia Theme.
"Ballad of the Windfish" from Link's Awakening is fantastic. YouTube it. It's good.

I hum it sometimes without thinking.
"Victory Road Theme" from Pokémon Red/Blue is still one of my favorites. Good luck finding just that one though. It's always mashed up with other music or gameplay. But, the song is delightfully ominous and upbeat at the same time.
Final Fantasy 6 Intro song. I think it's called "Omen". But, it's one of the best songs in that game. I also like the Opera song in that game too. Both stand out for me.
Chrono Trigger's opening song is fantastic. It's not the right one unless you've got the ticking clock with it. I also like each character's Theme Song, particularly Frog's. The rest of the music of the game is "okay" to me. I just like those ones.
Final Fantasy X. The only song worth talking about in that game is "Otherworld". It's my favorite song from that game. The only one I don't get tired of listening to.
Earthbound. Literally every song in the game. All the songs. Fantastic soundtrack. I love them all and they all bring me back to that game.
M4 Part II by Faunts. Anyone who's ever played Mass Effect knows this song. It is quite literally one of the best songs in the franchise. I love it and it always brings me back to memories of that game.
"Kill The Sound" from Dead Rising 2. I love that song and it always brings me back to that game with my friend.
The Original Super Mario Brothers Theme Song. You know the one. You really do. I always get a hit of nostalgia from that tune.
Tetris Songs. Particular for the Original Gameboy. There's that one song in particular... I think it's the Theme Song. You'll hum it all day long.
"Still Alive" from Portal 1. Always brings me back to Portal. For that matter...
"Want You Gone" from Portal 2.
"Re: Your Brains" always brings me back to Left4Dead2. My friends and I used to play the song while we played the Infected on the game. Oh, and if you click a Jukebox in the last level, it plays the song too.
"Glitter Girl Evil Side" by Morrison Poe, I believe. Even though Perfect Dark Zero was a crap game, that song was awesome and was basically what I expected from a Perfect Dark game... except none of the awesomeness of the song rubbed off on the game. Still, I jam out and think of Perfect Dark when I hear it.
"Ain't No Rest For The Wicked" by Cage The Elephant makes me nostalgic for Borderlands 1.
"Short Change Hero" by The Heavy makes me nostalgic for Borderlands 2.
Okay, there's a ton of music from video games that I just love and makes me want to play those games again. I'd be here all day if I listed them all.