The mod situation at DA:O appears to be moving out of the simple face/hair change mods. A good example of this are these two, which I am currently installing and will be checking out:
Dragon Age Redesigned Version 6.3
Please be aware that these are huge mods that change major aspects of the game, so it is not recommended that you use them unless you have played through the game at least once. In addition, you need to read through the accompanying description information carefully to ensure they work properly, that you are ok with the changes they make, and that they will function without conflicting with your other mods.
Improved Atmosphere significantly changes the milieu of the game. It adds ambient NPC's in many areas that move around, makes dead enemies not disappear, adds more party banter triggers, changes the levels of armor NPCs wear, changes the behaviors of merchants, changes the items you get in your origin stories, adds new item drops, changes or adds approval for finishing quests, adds a whole new class of armor material ("Hardened Gold") and so on. All of this is editable, but you have to read the directions carefully.
Dragon Age Redesigned changes the look of your companions and most of the named NPCs in the game. The changes occur via an installer, so you do have some control over what is installed or not. For example, you have the choice of three settings: Lore (for example on this setting Wynne looks older), Aesthetic (makes the NPCs look prettier or more balanced), and Recommended. You can also choose whether to change the look of your companions (Morrigan has 3 or 4 versions) or not. There are numerous image files on the authors page (use the tabs/links right above the Description section to move to Images, Files, Comments, etc.). The mod is being updated today (2/24), so you may not be able to access it until the update is complete.
These two mods are great for replay, since they really change significant areas of the game. However, they also have the potential to conflict with other mods like More Hairstyles, Don't worry Be hairy, Combat Tweaks, Pineappletree s Vibrant Colors, etc. so please be aware of this. In other cases, like in certain versions of Morrigan, they may require another mod (in this case, More Hairstyles) so read the directions carefully.
For ongoing mod development, check the Top Lists page at Dragon Nexus: Top Lists
Now, if you will excuse me, I need some me time in my Personal Castle and Harem mod...