I think Hood should be remembered as a talented brigade and division commander, one who inspired his men and one who didn’t ask them to do something he himself would not do. He was brave to a fault and a devout Confederate patriot.
I think as a corps and army commander, he tried, had some good ideas that he wasn’t able to carry out, and ultimately was given an impossible job in defending Atlanta. After the fall of the city, I think he conceives and begins what is a desperate campaign, but it’s also one that really is the only hope the Confederacy has at that point. To not go on the offensive just sets the stage for a long defeat.