I voted in-between. It's true that his ambitions were good, and like Liang Erdao I liked him a lot in the beginning. However, I think a lot of his early successes have to do with his background. He had a lot of good followers, and support from the other lords, but I think that's mostly because of his pedigree and prestige. Many of his early deeds are expected of him, like patriotism and leadership, given that he came from a long line of Han high officials (3 dukes in 4 generations or something like that). But his own resources ran out, even as early as at the end of the Dong Zhuo campaign. Why didn't he lead the lords to pursue Dong Zhuo to Chang'an, and why couldn't he have restrained Yuan Shu, if he really was a good leader? Also, if he really was so inspirational a lord, why did the people under him have their own plans for glory and fame (as Zhou Yu pointed out)? If he really was so clever, why couldn't he discern the right decision from all that his advisors tell him?
I wouldn't say that he's a fool. He's just mediocre, and undeserving of the empire. He might have been a great lord during times of peace, but when the world kept changing unexpectedly he failed to cope and survive.
"Whatever you do, don't fall off the bridge! It'll be a pain to try to get back up again." - Private, DW 8