If all you do is run in the corner and mash Forward Triangle, then no, he isn't fun; you're going to miss a lot of shots, and you're probably going to die.
If you run to the corner and actually aim/time your shots, he's a blast to use. Especially when you land those jumping sniper shots on people who think they're safe in the air. Just make sure to practice handling up-close situations, because it's a bit tricky and his tools are limited.
"The best things in life must be taken... by force!" ~Captain Khan