Just curious for the history buffs, was George Armstrong Custer a hero or a fool?

Both.

Fool

One must keep in mind Custer's motive. He did not want to share the glory with Crook, Terry, or even Reno. He had a strong desire to be President. He may have actually succeeded had he won a major victory.