I'm looking for... not necessarily the most acclaimed compositions, but any really good stuff that people actually actively listen to. I'm going to try and get the Carmina Burana and some Nicholas Paganini, but apart from that I don't really have much of a reference point apart from your stereotypical "Beethoven and Mozart" response. Preferably epic stuff; I'd prefer instrumental stuff to operas or soundtracks, but whatever. [spoiler]The other reason for this thread is to see if there'll be any "CLASSICAL MUSIC IS BAD AND YOU SHOULD FEEL BAD" responses.[/spoiler]
Yngwie transcribed for piano. Nuff said.
I've heard [url=http://www.angelzoom.de/]Angelzoom[/url] are pretty good, but I never really checked out any of their stuff to say. They seem to match your description though, judging by some reviews I saw.
Popol Vuh and Icebreaker.
Yann Tiersen. :D
Well, anything by Michael Hoenig and Jeremy Soule is orgasmic.
Rob Dougan's stuff is good.
Modest Mussorgsky's Pictures at an Exhibition is my favourite piece of classical music ever, it's quite catchy.
sigur ros (any of their cds are great) and B-Tribe (kind of like enigma)
John Williams and Klaus Badelt.