A whole lot of people are very hesitant to make their hero appear weak, as the people we look up to personally are in our eyes virtually untouchable. So, with this in mind should a hero be allowed to fail, knowing it shatters that view of them? Yes, but temporarily.
You don't want the story...