I wouldn't say that he's a bad guy but he's definetly not a good guy.
He's becomming an elected autocrat.
Most of the things he says about the United States are pointless saber rattling. And at times are completely tasteless (George Bush being the Devil at the UN)
He's trying to spread his influence throughout South America (sometimes successfully and others not).
He supports nations that just have a simple anti-US policy, Cuba, Iran, and Syria. It doesn't even matter if they are terrorist supporting nations (Iran and Syria), the only requirements for Mr. Chavez is "anti-US"
And the truth is that he would have no power if it weren't for his precious oil.
If Venezuela gets a Security Council seat, it will be a horrible waste of one on account that it would only be used to speak against the United States, which Chavez has admitted.
However, I do beleive that he really wants to help the poor.