I agree with the metal. Or any heavier music. Although a well placed techno song as Robertogo mentioned can make a big difference. Have to agree with Daft Punk but Ill add Prodigy and Depeche Mode. If you really want nerdy though listen to a classical piece like chariots of fire.
But lately working out at home I put some cool tv series on the tv. Keeps me entertained as I used to get bored and then not exercise as hard as I should. I particularly love watching stuff like the ultimate fighter/making the cut/bully beatdown/the contender. I find all fight series and movies somewhat motivational.