The best I ever found was Battlestar Galactica. It is a great mix of different types of music that, somehow, always hits an uptempo combat song when combat gets exciting. There is also like 20+ hours of music, which means it never gets too familiar and you can just loop it for an entire campaign.
As an aside--there is one track called Battlestar Muzactica that just does not fit at all (think space polka) and is all of a minute long. Evidently it played in the background of some bar scene that I never noticed. At any rate, we had a rule that if Battlestar Muzactica came on and you stood up and danced for a full 360, all of your fate points (action point alternative) returned. One fateful session the BBEG of the campaign arc got a bit too lucky and was about to TPK the party. On comes Muzactica, they all jump up, dance like idiots, rally back, and pull out a win. It was epic and I was relieved because I was pretty darn invested in the camp by this point.
I'll always respect Battlestar Muzactica for that.