http://www.youtube.com/watch?v=5YNeAYL6Bps If you listen from 0:00 to 0:45 or so there is a very dramatic piano piece playing. Now if i searched "dramatic piano songs" in google/youtube i get bad results as its not really dramatic. So yeah. Requesting songs similiar to 0:00 to 0:50 of this song. IMPORTANT NOTE: The rest of the song sounds terrible to me. Dubstep is bad.
This one is cool- http://www.youtube.com/watch?v=xYYOtEZeQl0 This one is intense, nice piano/keyboard riffs throughout, and a nasty keyboard solo near the end- http://www.youtube.com/watch?v=sA079BM0MuM You can find good, modern piano/keyboard work in most progressive rock/metal bands (eg: Dream Theater, Liquid Tension Experiment, Symphony X, Between the Buried and Me, Shadow Gallery, Jordan Rudess, Devin Townsend Project) You just need to find the right songs!
If we're talking about sick piano skills then here you go. Mirai Nikki OP - Kuusou Mesorogiwi [piano]
Moar. I clicked on the neo classical link and listened for a while, all i heard was slow, sad classical pieces. http://www.youtube.com/watch?v=IunstAdGBP4 more like that^
First off Justice isn't dubstep. They're an Electro band. Electro and Dubstep are completely different. Secondly, what is it that you like about the opening? Is it the atmosphere and mood? Or simply the piano? [Edit] Anyways give 12 Girls Band a listen. Pretty amazing stuff. All traditional Chinese instruments. http://www.youtube.com/watch?v=BVMXEnL8liM
This. And I'll post Mana just because it's an awesome song and I love posting it. You'll likely enjoy the intro to it. I dunno about the rest since it shifts tones a few times, but you should enjoy the intro.