Kefka was an effective villain because he was completely insane, and that made him somewhat scary.

But, I also felt that he didn't have much developement at all, which makes him somewhat uninteresting at the same time.