I personally think that running out of fuel should have never happened. From my understanding, Capt Robert Piche thought it was a fuel imbalance, shut off one of the engine valves and tried to cross-feed to the other engine. What he didn't realize (till the last min.) was that the engine was actually malfunctioning and all that was transferred ended up over the water as dumped fuel. It was engine fuel leak.
Therefore I don't see him as a hero. I see him as an idiot, who, in a desperate/panic mode, landed the plane safely without power, flight controls and fuel. The PIC (and maintenance) together have to ensure flight is carried out safely. Well, they didn't. They made the pax go bananas, like a ride to hell.