It felt like the game was pushing for me to be a mage, honestly. All the anchor this and fade that- it all comes together neater if you've got some foreknowledge that might inform your flailing attempts to control the crazy you've been tossed in the middle of. The Dalish stuff only came later... and that was a pretty nice payoff after how disconnected the Dalish Warden felt from most of the things going on in Origins. To my mind, it works like this...
In Origins, Dwarves get the best payoff, followed by the City Elves and Mages. I lean more towards the Dwarf Noble since you get to spend about a quarter of the game knocking around your old haunts, and if you play your cards right wind up as a Paragon to boot (which is all the sweeter having actually met two of them by that point). The Dwarf Noble payoff is just so satisfying. You can choose Bhelen's fate just as he chose yours- either congratulate him on a game well played and put him on the throne, for which he actually expresses gratitude and rewards you with a title that's, all things considered, superior to his own, or you can become his worst nightmare and force him to watch as you methodically take his plans apart and ruin him. The Commoner Dwarf gets to play a pivotal role in changing the history of Orzammar, and that's pretty satisfying too- especially since the sister becomes royalty if you pick Bhelen, and you get to take down the Carta personally for everything they ever made you do.
The City Elf gets to be the Big Damn Hero and return home to save the day. Twice. Even without much reward, it feels right... but that's only a small part of the game.
Likewise the Mages... you can return home and either save your firends and mentors or unleash your cathartic fury on the prison you spent your entire childhood in. Having Wynne along for the ride makes you not feel quite so alone in the world as the other Wardens are- the Human Noble gets their dog, sure, but you can't reminisce and commisurate with a dog. You get the tie-in with Jowan at Redcliffe as well, which is nice.
Dalish Warden doesn't really get a payoff at all. You can make small talk with some of Zathrian's clan, but you're still a stranger there. You don't get any closure on your clan until DA2, and that's not really the same because it's not you who's getting the closure at all.
The Human Noble? Well, you can put yourself on the throne (or one of them anyway)... but the revenge against Howe falls flat. He has almost no involvement between getting his murder on and getting stomped into the basement floor. You get a few throwaway lines from the various other nobles you run into, and it's a little easier to sway the Landsmeet. There's not any sense that your personal history is intimately involved with one of the four major plot quests the way there is with the Dwarf. Still, it all feels a little hollow because you spend so little of the game in and around the people and places your Warden would have known well. You're denied the satisfaction of having the last word when you kill Howe, and you never get to see your family given a proper funeral. You never get to go home again- there's a marginal improvement if you import to Awakening, because then you can play Meet the Howes and take over the greedy bastard's castle and lands... but it still feels a little weak.
DA2 railroaded you into being human. Snark!Hawke is a total gas and scratched the fallen nobility itch in a way that the Origins Human Noble just didn't (with the whole business of actually going and reclaiming the estate and titles). The whole story was the connection, no further comment needed. Okay, so we have our human-focused installment.
So I wound up with a mage Lavellan for DAI. It was every bit as satisfying as the Dwarf Noble was in Origins despite the utter lack of meaningful involvement from my clan. I got to dig around in ancient ruins and recover important pieces of elven history... and ultimately wielded power granted to me by the very goddess whose markings I wore on my face. There were more than a few missed opportunities- like nobody, Lavellan included, even once mentioning the fate of the clan one way or another, or the bit of derp with her asking who Mythal was... but overall there was a lot of immersion fodder. Way more than I expected, including unique dialogue with Harding of all people when we traveled to places of great significance to the Dalish and she commented on them. Ancient, secret temples... several of them, and two were completely optional. Just the kind of adventure a young First might have been hoping for when her Keeper sent her to far away lands on a mission of grave importance to the People! I got to do what Merrill was only hoping to in DA2- I got to actually pass through an eluvian, more than once, got to meet actual ancient elves who'd never lost their immortality, and recovered more of elven history by pure dumb luck than any other had in the past thousand years through a lifetime of research and toil... and I had two of the gods looking over my shoulder while I did it. The human Chantry might have ultimately decided that Lavellan was chosen by their Maker, as though she'd ever asked to be venerated by them... but by the end of the game she was pretty sure she'd really been chosen by her own pantheon instead!