When it comes down to it, Dragon Age II actually was one of the few CRPGs that I've played where the main plot only involved a local political matter. It's another reason why I regard Dragon Age II as a hugely missed opportunity. Instead of the trite old trope where the player gets dragged into a battle against some ancient evil or some evil nemesis plotting to take over the kingdom, we had a much more interesting plot idea of a power struggle between two political factions with no clear right or wrong side.
It's the main reason why the "Ha! They're both one dimensional bad guys" ending was such a kick in the teeth.
I would agree with you one that, DA2's storyline did make a change to the typical RPG "save the world/kingdom" and that it was set just in the one city was brillant. the side quest of Hawkes mother again brillant. Sadly the way it was implemented was poor mainly the reuse of the same interiors, the way they turned into an action game ala darksiders and the ending was very badly handled why they turned the 2 end bosses into one dimensional characters is beyond me. Not sure what happened to DA2 because it had really good ideas and storylines. I still think one of the main factors was that the game was out incredible fast, to fast i think, just 2 years after the first one, development time that is not long.
I hope that Dragon Age 3 is better and that lessons have been learnt, i am hopefull as DA3 is due out to the beginning of 2014 which gives it a longer development time and from what i have been hearing Bioware are listening to the feedback about how not to make a repeat of DA2.
Also in a interview;
Ray Muzyka, BioWare's CEO, said in an interview with Wired.com that Dragon Age III would be influenced by more open world games, such as The Elder Scrolls V: Skyrim, which BioWare is "
checking out aggressively." Also, the developers promised their fans that they will no longer reuse environments, which was considered a main issue in Dragon Age II.
From that i think Bioware are going in the right direction. I do wonder if DA3 will conclude Hawkes storyline as Bioware said further DLC for 2 would finish his/her storyline but David Gaider has stated that there will be no more DLC for DA 2.