VII's Cid is still my favorite. Besides having a pretty good backstory and giving some comic relief, he also happens to be a very useful party member, with an 18-hit Limit Break, a triple growth weapon and the Javelin, a weapon with a total AP gain of 10 materias, which is AFAIK the highest in the game. I like how his past issues are resolved during the course of the game and he becomes a very sympathetic character at that point. Before that, well he's not exactly good at anger management, but he was still an awesome guy. My lack of negativity towards his early personality might stem from the fact that I knew he would eventually redeem himself long before I ever played FF VII myself.