I dont think there any really good new content mods out. there are a few that repair npcs dialogue though - i got morrigans fix:
http://www.dragonagenexus.com/downlo...le.php?id=1120
other than that, you might try the mod which enables you to keep dog in an extra companion slot - it will make the game slightly easier, but then you get more dialogues between various npcs and dog.