I've been playing piano for several years now, and I share your gripes--about classical music, at least. Jazz piano, though, is in an entirely different world for me. I think it's beautiful to listen to, and extremely engaging to play. Not dull at all, either, if you've got a good score.
I do think pianos, especially in modern music where other instruments are involved, don't get a spotlight, but they don't always deserve one. It's a wonderful instrument, but accompanied with lyrics and other instruments it can sound... wrong. Like excess filler. But it can be used really well.
It depends on who's playing, and the type of music. Yeah.