I'll leave my no doubt tedious advocacy of classical music aside here - and leave jazz to the experts.
Some of the greatest hip-hop beats ever sample the piano. QB - Mobb Deep/CNN, etc. especially stand out.
And a lot of great house music - again, New York house of the Mood 2 Swing variety springs to mind. And as mentioned already, hardcore.
I play the piano btw, but not in pubs/public. I'm not a monster.
It's definitely died out as a sound in modern music, right? Other than hideous crooners and damp indie music. But the same is probably true of most acoustic instruments.