Okay I don't want to get into this long debate but if I may just throw my two cents in I'd have to say that I loved Kefka as a villian. His "insane" nature just really made me smile to no end, if anything I just found him incrediblly fun.

Oh and honestly if we're going on what villians we like and dislike; if they made a villian that is as well developed and generally magnificent as Palpatine from Star Wars I'd be happy.