My personal favorite has to be K.Rool duel. Ever since I first heard this tune when I was a kid I was so blown away. The fact that it turned from a jittery pirate tune to some awesome rocking music pumped me up in ways I never felt before XD.
Second favorite is underwater for the calming atmosphere, third runner up are the misty mines, for their gloominess.