I also think there is an internal dilemma in the consumption of heroic myths. A vast amount of people struggle with the best and worst versions of themselves. Thus the plight of superheros can act as stage where we see various aspects of our own demons slayed for example greed, machiavellianism, destructive urges, etc...

We revel in the explosions and the vast levels of chaos that ensue in these types of movies and at the end the hero allows us to reconcile with these thoughts. So that we essentially watch the world burn and then restored and thus we flex the muscles of our deviant thoughts and our ethical frameworks.