"Maybe the best D&D music ever comes from Basil Poledouris's soundtrack for Conan the Barbarian. Every player of a fighter or barbarian wants to be Arnold. If you play this, they will be. Of course, if you play it, don't expect them to find diplomatic solutions to problems."
--Mike Selinker, "The Definitive D&D Soundtrack," Dragon 272, Sept. 2000.
Let's face it: the original 1982 Conan the Barbarian movie would probably have sucked without this awesome soundtrack. Yes, there's bloody combat as Conan carves his way across the world, but there's lots of introspection, wherein the music plays as prominent role in carrying the story forward.
And if you haven't seen the original the movie (sorry, the 2011 version doesn't count), then you need to watch it.
The "Anvil of Crom" is the staple song of the soundtrack. It can used for combat, dramatic entrances, and so on.
"Theology/Civilization" is one of the more introspective of the tracks.
"The Battle of the Mounds" features a slow build up and then its with a climax suited for an epic battle.
I can't stress this soundtrack enough. If you don't have it, buy it. Get it. Watch the movie.
You'll see why both the movie and soundtrack have been popular among gamers for more than 30 years.