Before I say this, an honorable mention goes to the opening for Super Smash Brothers Melee, which is a great piece of music. Definately gave an epic feel to the game right off the bat.

I can't be certain of my favorite, but I will tell you two that definately made me feel alive.

The first that comes to mind is one that was based on a certain movie. All the music from this game was awesome, but the final piece of music was truly a masterpiece. The moment it started, you felt a rush, from not just the music, but everything... Goldeneye64, Battle with Alec Trevelyan.

The second isn't really a favorite theme of mine, technically, since the game isn't even out yet. However, it shows that Nintendo puts everything they've got into every aspect of their games. Don't Want You No More by the Allman Brothers Band. It's the trailer theme for The Legend of Zelda: Twilight Princess.