In terms of pure nostalgia rushes and songs I like there are a couple...
Wizpig's race theme from Diddy Kong racing is just a nostalgic overload. Diddy Kong Racing was the first game I ever played. I heard this song a lot on my childhood as my dad and I tried to beat Wizpig for the first time. Seriously if that beginning rift to that song didn't get stuck in your head by the time you were done you weren't playing Diddy Kong Racing.
The ending credits from Sonic Adventure 2 is also a song that brings a rush of nostalgia. SA2 was my first console game I beat on my own and was my introduction into the sonic fandom.
Meaning of Birth in Tales of the Abyss. I was pretty high on this game for a while I had played Symphonia and liked it but this is the Tales of game that I REALLY got attached to. I loved the characters and the story was just pure joy. So when this song kicked in during your final battle with Asch I lost my ****. The music just fit so god damn well. It gave me this rush of energy to just plow through the rest of the game. The song is just so energetic and epic I couldn't contain myself. Funny story to that song is that I was actually spoiled to it before I even played the game. I thought the music was awesome and that's the reason I played Abyss to begin with. I didn't know an orchestral pice would lead me to putting this in my top 10 games of all time list. I played through the game waiting for this track to come up and when it finally did I couldn't help feeling "Yes, this is the perfect placement for this song." If anyone else played Abyss and liked it I think you would agree.
And the ending melody to Pokemon RBY. It was the first game I beat on my own flat out period. So when it ended and the ending theme kicked in I got kinda teary eyed, I still do. And this was back when I was only 8 mind you, I was affected by this game that much. The ending to GSC is also kinda like that but not as much. Just when that beginning portion chimes in I just feel my heart well up because THAT's my childhood. I've never felt something as emotional as beating that game...until recently.
However, the
ONE song that never fails to give me feels
Kiseki, the ending credits to Pokemon X and Y. I know it's super recent but god damnit if that song didn't ever give me the feels. The only times I've ever gotten misty eyed to a video game were Pokemon RBY, SA2's ending, Tales of the Abyss's ending, and now X and Y's ending. I don't know I think it's because I marathoned the game hard. I truly did love almost every bit of X and Y. I haven't felt this way about a Pokemon game since RBY. So by the time I beat it I felt like I was 8 years old again. And god damnit when this song came up I couldn't help let a few tears out. The lyrics just want to make me rip my heart out, even when I just hear it. I don't think it has as much weight as it does just beating the game but it really is an emotional joyride that I can't get enough of. Every time I hear it or look at X and Y I say "THIS is why i'm a pokemon fan, THIS is why I love this series so much and THIS is what i've been waiting so long for." No other generation up to this point has made me feel literally overwhelmed with emotions, again bar RBY. Its a generation that I will continually return to and will always hold dear in my heart. One that truly re-sparked my interest after 4th and 5th gen left me so empty and wanting.