Sacred Haven of Debauchery

Dark forces, spawn of darkness, Archdemon – whatever you call them, the essence remains the same: something “evil” threatens the kingdom/planet/galaxy, and only the main hero can save everyone.

Spawn of Darkness is a natural disaster. Even the Archdemon is not rational; they act instinctively and out of habit, but not rationally. Except for those who have retained their sanity. But the latter do not participate in the Fade.

and only the main hero can save everyone. Dragon Age is no exception.

Loghain and Alistair don't count, do they?) Moreover, the developers even released an alternative story where the Grey Warden dies, and the mission falls on Alistair's shoulders, although our protagonist kills him in the plot.