No, VII is much better than VI.
Terra is even more emo and whiney than Cloud, people just tends to overlook that a lot more just because she is a she. As for the badguy, Kefka is just the Joker in FF terms, everyone loves it, but as a character has the depth of a puddle. Sephirot is in a completely diferent league, the very fact on how both characters are handled and introduced separates appart, the first of sephirot you see in VII you play, and you feel him being extremely powerful, introducing a sense of dread everytime you are getting to him since you already know how strong he is, Kefka is basically comic relief till like 10 hours into the game and gets serious for a brief moment till again the very end.
