None of the super-powers are useless, but all the ones listed are definitely more situational than the others.
They work very well with certain cards and strategies, and need patience and timing.
Yes, I see a lot of players using them poorly. As far as I'm concerned, Super! I love easy wins.
I also agree with jaydabbler's analysis, except...
Whirlwind may be my least favorite super-power, but when my opponent throws an Octo-Zombie in the first lane to finish the match off, and I happen to have a Whirlwind in my hand, I certainly wouldn't be calling it useless at that moment.
