Well, there's another kind of story we tell about heroes: the Tragedy. The hero falls and the villain wins because of a hero's fatal flaw. Where normal heroic stories exist to communicate our ideals, tragedies exist to warn us of the failures that can lead to our undoing.
Been a long time since...