I love it. Because when used right, you don't even notice that it's dissonant. A great example is classical piano music, when played in it's complete form, you don't notice it, but in a lot of the classical stuff (And modern as well) if you play just 1 hand at a time, you'll notice a lot of dissonance in the music, but the other hand compliments it and smooths it over, making it sound gorgeous.
I don't do much dissonant stuff on piano, because I don't know how to use it properly yet... but I do it a fair bit on guitar when I'm writing more "in your face metal".... But then... I intentionally make it sound dissonant.
I use your typical powerchord but raising the lowest root 1 semitone often in chugging sections of songs... So instead of D-A-D, it's D#-A-D... Gives the chord a very sinister and foreboding sound.