In my opinion he is a great card depending on the type of deck that is run around it. The key is to run stuff that stops your opponent from obtaining additional battle rewards once you let them get to 5 for desperation.
I ran a deck in a tournament this month with him and I made it around a Fire/Wind/Water. I utilized a few key things such as the new Kurenai to stop BR wins, Inner Sakura to chump block, and Stone Council to bring back rewards. The other key to success with me was to use The Strongest One mission which kills both fields ninjas except one for each player. If you leave Susano'o in play and then do his effect your opponent is left with nothing. Along with running Hidan to come back from discard and maybe another Kurenai on their next turn you have a good turn 6 master curve.
Like I said though that's just my opinion from what I ran, did well for me.