Why would we complain about villains? It all comes down at personal opinion again. Will bad villains ruin a for the rest terrific game for you?

We have better and less villains, but I never had a villain I said: "God, what were they thinking at SE when they made this guy/girl?"

Sure, Kefka is a clown and perhaps he acts pathetic, that's just because he being infused with Magitec drove his grey cells nuts. Now he just wants to destroy all life because he finds it unworthy.
Sephiroth, yeah, I give it, he's a big baby with an enormous sword. He can't even destroy the world by himself, he needed a big rock for it. So? He still is cool to slaughter and has some nice battle music (Birth of a God, One-Winged Angel).
Kuja, he dresses like a girl. You say his intentions aren't threatening? Ahem, is blowing up a world all by yourself (take an example from him, Sephiroth! Well, except when it comes to clothes) not bad? And after that, he wants to destroy all, thinking: "If I die, everything goes with me."
I can't say a thing about the VIII, X, X-2 villains, since I never played them.
However, which I is also considered a very bad and pathetic villain, is this huge armoured guy we know as ExDeath (or Exodus, for that matter). The thing everybody hates about him is his name. People, wake up. What for a name is Chaos? or Cloud of Darkness? This guy actually cleared teh way for Kefka. I liked him. He was even better than Zeromus. Big Z, ExDeath and Kefka all share the same goal in the end, did ya notice?

Well, that all aside, nobody who will botehr to read this, it comes down on personal opinion. For me, not a single villain is 'pathetic'. You have better and less good villains. But all were good, in a way. So... Yeah...