Personally, I find the Mage origin to be very excellent. It ties directly into what happened at Redcliff Castle, and teaches you that I consider the Mage origin in my top three origin stories, next to Dwarf Noble (oh lawdy, I do loves me some political intrigue), and the City Elf (racial segregation and social class differences... among other things).
I consider the Human Noble to be the worst of the bunch that I've played (haven't done the Dwarf Commoner or Dalish Elf origins yet).
In my Mage playthrough, I became a total jerk. I chose all the "bad" allies, but in doing so
Bookmarks