Now this is actually an interesting reply. Given a chance that a player would provide his/her own category for MODs, people would suggest some that befit their taste. To find that Character Respec is a bit too much of a change, would make us rethink of your extent to modding your next run. I also understand the "SO overwhelming part" as I am still trying to make some of mine work together. In your case, at least mentioning that you're savvy enough makes other also comfortable to recommend freely.
So... let me do my best on this one. There are many more but I can only speak for the ones I use(d):
Environment:
Improved Atmosphere: Lesser stagnant NPC, bug fixes, more banter triggers, improved vfx
Extra Dog Slot: A fifth slot occupying the Warden's or Alistair's summon slot. Incompatible with some MODs
Pet Persists: Summons and pets don't die or be removed when changing maps. Some MODs already have this.
Combat related:
Advanced Series: Allows additional slots. More tactic options. Force backstab on rogues (optional). Force tactics over controlled character (optional).
Advanced Tactics,
Advanced Party,
Advanced Quickbar.
Combat Tweaks: Conforms to most of player(s) complaints with combat (activation/deactivation of sustained abilities, ability vfx, poison duration, etc). Needs some tweaking especially when combined with related MODs.
Deathblow Multiplier or
Forced Deathblow: More chances of seeing characters do the final blow animation.
Personal:
Helm Removal: Memorizes which hat you wore, unequips said hat during exploration, auto re-equips said hat on combat. Awakening requires the
other version.
White Teeth: In hopes that your love interest would brush his and/or her teeth regularly.
Lots and lots and lots of hairstyles
Change Warden Hair and Face anytime in-game: I have not had one unhappy user with this one yet.
9999 items: Increases the stack limits of all items (some view this as cheating, some don't)
Madd Gift Guide: Have you memorized which gift suits best or each companion yet? Really?
The Icons Project: Small and humble MOD but makes a good difference.
Extra Game Content:
Alley or Murders: I'll be banished from this community by the power of AmstradHero if I don't mention this. Get this one!
Castle Cousland: Good additional content especially for Noble Origin
Temple of Vulak: Want a challenge? Here's one.
Dark Times: the DA community will chase me with pitchforks (and kitchen knives) if I won't mention this.
The Bloodworks: Won't harm you to try this one too.
There are plenty more (and I've kept some that I think you won't bother looking) and I'm sure other users would love to suggest them. But be warned that using all of them at the same time will take some challenging feat to make them work together. Don't let this fact deter you, though.