Your a refugee trying to survive and get a better life and after becoming the city's champion , trying to protect and maintain the city safe while being in the middle of a possible civil war between the mages and templars. Way more interesting than '' You're the *insert chosen one tittle here* and you need to get allies and form a army to the defeat a greater evil'' plot of DAO or DA:I.
What's Hawkes motivation?
Literaly trying survive and get a better life in that shithole for him/her self and his/her family/friends and later trying to prevent a civil war of happen to project the city. Idk sounds like a very simple and clear motivation.
Why the fuck that city, and then why to leave at the end and hide somewhere like a little bitch and not take over?
Because the writers didn't had the balls. You can become Viscount if you side with the templars but Bioware just like what they did with the Warden (''Warden is looking for a cure instead of figthing Darkspawn that's close to godhood!'') and Leliana (if she died in DAO) , retcon this shit and created a bullshit excuse to make Hawke apper in DA:I , something about Hawke being betrayed by the templars and exiled because reasons like every bullshit retcon because they're too lazy to create actual consequences..
Btw Orsino wasn't suppose to be a boss in the mage route , but they create a bullshit excuse to make due EA wanting to have 2 bosses in both endings.