Human Noble was my favorite, because the fact that Tim Curry provided the voice for a character in the game was a major selling point. So more of him, and having his villainy really matter to my character, was a bit plus.
The City Elf origin was also quite good. Overall, I'd say that the Mage and Wild Elf origins were the weakest. The mages because the whole "magic is evil, let's prove it by tempting you with demons" thing seemed rather stupid to me, and the wild elf because it was pretty much dropped after you finished your origin quest. Felt like you weren't really part of the world in the same way that the other ones were.