...But seriously, if you're okay with non-metal bands (well, mostly non-metal), the most beautiful album I've ever heard is "Sombre Romantic" by Virgin Black. It's a masterpiece. Classical/metal type stuff mixed. Extremely sad, but soooo beautiful.
And since I'm a classical pianist, I'd suggest Wladyslaw Szpilman. Buuuuuuut, I'm sure that's not what you're looking for.
...Geeze, I'm making myself out to be a pussy.

I never really considered that a song to throw the horns up to and headbang

Exactly.

Dream Theater or Symphony X

Nightwish is a pretty cool band that has keyboards theyre drummer is very good 2

I'm not a piano nut, but I like what Zakk Wylde does on the Mafia album

__________________