I think it was pretty much agreed that a good chunk of Chavez's rise was luck, coming to power at a time when oil revenues in Venezuela were skyrocketing. He nationalized those revenues, and used them, if not wisely, at least shrewdly for his own political interest, shoring up his own base of power and support. Certainly some of the projects he undertook were good for some of the people, at least in the short-term. Late in his career, the revenues proved insufficient to support both critial long-term projects and the populistic program he had initiated for the purposes of his own career, and it was here that he put his career ahead of the national interest. He borrowed too much, and used the money not to advance infrastructure projects that would pay long-term dividends, but for short-term social programs and untenable fuel subsidies. As a result, the next president will have some very hard choices to make between deep social spending cuts to modernize the country's systems or mortgaging the country's future to build political capital.
In the end, I think Chavez will be remembered as a shrewdly self-interested politician, not as a national hero.