One word: Queen. For the dramatic, or humorous moments of the campaign, nothing beats classics like Princes of the Universe, and Another One Bites the Dust. Generic video game music, like the Vampire the Masquerade Bloodlines soundtrack, or sound files if you have the game installed work wonders.