But the first other template to the 'heroes' story would be the tragedy which is not simply a subversion of the heroes story. After all tragedies are as old as the hero's journey and as well loved. Comedies are often not this either, as they often ridicule the hero in every turn and the protagonist often end up having travel essansial nowhere. They are also really, really old.
At times, I felt that Hawke's story was a Tragic Comedy. Or a Comic Tragedy. Not sure if there is a difference.
It was a story about someone who tried to be the hero - to themselves, to their family, to their friends and to a city - and failed. In fact, if Hawke had died outside of Lothering instead of Bethant or Carver, I've postulated in the past that everyone's lives would have been better, outside of one or two people.
Varric and Bartrand wouldn't have been able to successfully find their Deep Roads expedition, or, if they had, wouldn't have been able to find the maps necessary to get to the Primevael Ruins, or, at worst, wouldn't have been able to fight their way to the idol. No idol, no crazy Meredith, no divide between Varric and his brother.
Isabella would have not had Hawke's help in remaining hidden in Kirkwall. This would have forced her to run away or be captured. Not good outcomes for her, undoubtedly, but the Qunari would have left once their prey fled or was caught, sparing the lives of many.
Merrill would have never had a protector in Kirkwall which would cause her to leave her clan, a choice that results in her mentor becoming an Abomination and dying and her clan being slaughtered or deserting her.
Anders would have either been caught or forced to flee, meaning he would have never blew up the Chantry and resulted in a civil war in Kirkwall.
Both the Viscount and the Elthina would have remained alive to keep Meredith and Orsino from reaching dangerous levels. Without the idol, Meredith wouldn't have reached her paranoid levels. And without Hawke's involvement with chasing off or killing the one real lead at catching the serial killer in Act 2, he might have been caught and killed, preventing his dark research from continuing.
Fenris might have been caught or he might not have. Aveline and Hawke's family would have died without Flemeth's involvement, but we don't know if Hawke was special there or if Flemeth just needed a pack mule to Kirkwall. If the pack mule theory is true, Carver, Bethany or Aveline could have sufficed and not resulted in so much terror being unleashed.
I had a few more examples, but I think this is sufficient. Hawke not only brings about his own downfall, in true Shakespearean style, but actively makes the lives of everyone in Kirkwall worse, by and large. Everyone who met Hawke likely regretted it. Hawke is the antagonist of DA2. Hawke is the reason everyone experiences terrible, terrible maladies, all disguised by a good intentions.