Certainly, he was never a friend of the United States, and this was exacerbated by the US tacit (and likely covert explicit) support of 2002 coup attempt against him.
As to how he was as the chief executive (and pretty much everything else) in Venezuela, I would not give him high marks, unless I were grading on the curve.
If I were grading on the curve though, he would get high marks against the previous ruling elites in Venezuela.
It is truly a shame that, when compared to the political elites who seemed primarily concerned with who got the loot, he was arguably a better leader.