For me, I really like both Dwarf origins, with Noble probably a bit more.
Dwarf commoner shows how bad castless have it and provides a unique outlook on the later part of the game, and is one of the few origins where joining the wardens really feels like a step up in the world. Although the ending of the origin feels rushed, a bit deus ex machina, IMO.
Dwarf noble is just amazing all around. So many ways you can roleplay your dwarf, and the origin adjusts accordingly- you can be an honorable goody two-shoes, or a scheming douchebag that is too noble to talk to your lessers. You can refuse to participate in the noble schemes, or play the game of thrones yourself- the end result is the same, but how guilty you join them differs.
As for the least favorite origin, I have to say it’s the City Elf one for me. I just don’t like how one-dimensional the villain is, how little impact it has, considering how traumatic the whole origin can be.
What about tou?
Yeah, dalish origin is pretty underrated. One of the few where your character has a reason to really hate Duncans guts and feel like they were being screwed by the wardens. Also I like that it shows how close knit the clan is. If you take your time to talk to folks around the camp, the final goodbye hits different. Also as a f!Dalish, Tamlens fate can hit really hard.
As for mage origin, its been years since Ive played it, but I agree mages take time to feel powerful in DAO, in contrast to the games lore.