In modern times, Halo. That theme is incredible.
I'm also a sucker for the original Zelda theme. It's irritating that Nintendo has basically abandoned the theme entirely. The a cappella theme in Sunshine during the secret stages was pretty fuckin' awesome, too.
Or check out my new webcomic: http://selfcentent.com/