For me, the game peaks in Act 1. After I was able to make some kind of peace with the (IMO) awful new conversation system, dull combat etc etc etc, I at least had some enjoyment out of the Breach questline. Breaking down Act 1, I felt the following:(there are no real spoilers here - its just general impressions).
Wrath of Heaven: A poor rushed start and my first exposure to the systems/combat of the game, all of which feel like a step backwards from previous games. However, it picks up towards the end and the sequence in the Temple of Sacred Ashes is one of the best in the game IMO.
Haven: I don't care how 'awesome' Skyhold supposedly is - Haven is much better. By grouping all the party members, facilities and War Room so close together, you can quickly and easily do a round trip of the camp, fix up and sell your gear, do your War Table stuff and then jet. Skyhold offers exactly the same thing, but spaces it all out and puts in stairs and loading screens to further waste time. For economy of time, Haven is by far the better of the 2 IMO.
The Hinterlands - Much maligned, but one of my favorite zones. It at least feels like stuff is going on here, and it has communities of people etc. Later maps feel much more empty and dead. Its not like its a massively fun place to game (quite the reverse), but at least I understand why I would be there, and feel like the stuff I'm doing (by and large) is stuff I should be doing.
Val Royeaux meeting - A short and pretty silly quest. Orlais and Orlesians are mostly played for laughs again in this game, which is extremely disappointing. Here, they just seem incompetant, and Lucius comes across like some kind of wrestling heel on Monday Night RAW. Fiona is more interesting, and is actually very well acted. Overall, the quest is short, silly and lacks credibility.
Hushed Whispers/Champions of the Just - Both quests have their moments, and IHW is very well written from a character standpoint. But its premise is extraordinarily silly for this game, and I can't accept it. Its a good quest - it just doesn't feel like it belongs in Dragon Age. Champions of the Just is the best quest of the whole game IMO. Lucius' voice actor hams it up terribly, but otherwise the quest is tense, action packed, has good characters and a tight, interesting plot. If only the whole game was this good.
In your Heart shall Burn - An awkward one, because it varies wildly from moment to moment in quality. The sealing of the Breach is an outrageous anti climax, the attack is excellent for the most part and one of the best parts of the game, the meeting with the main villain is atrocious (as is everything involving you directly in this quest - everyone praising you for pulling the lever on a Trebuchet that other people prepared and aimed, you later doing all these things by yourself, despite that being basically impossible for even a trained artillerist, let alone 1 untrained person who is under attack at the time etc etc).
And the Singing Scene... I'm sorry, but I just cannot stand that ridiculous scene. Its so unbelieveably hokey and cringe inducing. I still haven;t managed to listen to the whole thing all the way through with the sound up. Its just too embarassing.
So not exactly glowing praise, but I can deal with Act 1. Rushed as it is, the explanation for why your organisation needs to exist is reasonable enough at that point, From Act 2 onwards, the narrative plummets off a cliff, Skyhold's removed genre friendly atmosphere basically makes this into Liberal Fanservice: The Game, there is never any strong justification on why your organisation is still in existence when others could fill the role now that the Breach and Mark no longer matter. The threat from the enemy is kept nebulous and largely absent, so its never clear what level of actual threat is being posed etc etc etc.
And meanwhile the game rumbles on, drowning you in new zones of the same old boring crap. The game basically gives up on its narrative at this point, becoming a King Simulator of sorts, and tries to distract you with the idea of building up your faction's forces and lands, without actually being specific on why any of that is necessary, given that you seem to fighting a guerilla and espionage war, rather than an actual land based one.
Ultimately the game swings back and forth between being insufferably boring and occasionally stupifying you into a bored, but at a very basic level contented torpor, as you repeat the endless sequences of menial drudgery, before being fed tons more incredibly stiff and badly executed trying too hard fanservice. At least, that's how I feel about it.