While you're doing those things, you get a bunch of story and lore. And everything you just mentioned is part of the main quests. Everything is connected
Well...duh ... the main plot quests better be connected.
Is this supposed to be some counterpoint to DAI's quest progression? It makes no sense to use this argument.
Were you expecting to arrive at Orzammar, "hey I need your army", "sure thing!" and that was it?
Of course not. Implying that the quest content is actually MORE relevant to the story than DAI's is absurd though. Why else do you think Shale and Sten disapprove of whatever you do unless you use the "I-WIN" persuade skill?
They do serve a purpose of expanding the game's lore of course and there's no denying that DAO did a good job at that. What else would have drawn me into the world of Thedas otherwise?
Again, claiming that DAO does it BETTER than DAI is arguably a product of player nostalgic bias, because DAI expanded on the lore that was previously established in previous games in an equally if not more vigorous way. In fact DAI deconstructed many misconceptions and preconceptions about previous constructs from Wardens to Orlais to Tevinter.
The quests themselves were pretty nice, my favorite being the Elven questline with a peaceful resolution, but the fact of the matter is that DAO's main quests are all based on the concept you doing favors for people for them to help you.
If you don't look at it from a meta-game perspective, your Warden very often had NO IDEA if helping these people will actually fulfill your goal.
They all had nothing to do with the Blight beyond potentially recruiting allies.
Even from a story perspective, Loghain is entirely irrelevant beyond Ostagar and the Landsmeet.
On the other hand, DAI's main quests are entirely based on you actually foiling Corypheus's plans. They're all VERY DIRECTLY involved with the main plot.
You never know how it's going to turn out and every one of those quests.
Even the zones ALL deal with Corypheus, his minions, OR the after-effects of their actions.
Riiiight, because something as important as the sacred ashes should be just lying around somewhere for anyone to take without being guarded or anything. But if you want to go down that road, What Pride Had Wrought is also a complete slog. The temple is right there, do you need to go through the jungle and kill the same generic mobs over and over again and then do the puzzles/tests to get in? You can choose not to do them, but then you have to fight some more mobs before getting to the well.
This analogy is all wrong.
You don't "slog" through the temple. It's a fairly linear advancement towards the temple itself.
When you reach the temple, you have the option of respecting the temple itself or not giving a fig about it. Depending on various choices you made, you can learn a great deal about the lore of elves and their gods. There is literally no equivalent in DAO for this.
Regarding the puzzles, my 5 year old cousin can solve them.