I'll weigh in for Morrowind mods:
I was looking for a stable game with fully compatible mods for mostly bug fixes, graphics and/or quality of life improvements. I'd love to take credit for researching/sourcing these, but they are more or less directly stolen from BTBs Morrowind mod list circa 8 or 10 years ago. His list has been defunct for awhile, but here's an archive from around the last time I downloaded all of 'em:
Edit: GOG ate my link, try this one in the wayback machine:
http://btb2.free.fr/mods.html I'll just leave the list of the ones I use, go with his descriptions if you want to know more about individual ones. Also, while I only use a fraction of what he lists, it's still a longish list so strap in!
Morrowind Patch Project
Morrowind Cod Patch
Timeslip's exe optimizer (program for xp machines and the loose file for win 7)
Visual Pack
Bloodmoon Landscape Overhaul
Correct UV Rocks
Slartibartfast's Texture Fix
Connary's Texures
SWG's Skies (with BTB's fix)
Vurt's Hi-res Skies and Weather (excluding the night sky one)
Better Bodes
New Beast Bodes
Better Heads
Better Clothes
More Better Clothes (with it's patch)
Canadian Ice's Robes
Darknut's Weapon Textures
Darknut's Armor Textures
The three god replacers (Azura Replacer, Vivec God Replacement, and Better Almalexia)
Mesh Improvements
Darknut's Creature Textures (and it's patches)
Herbalism for Purists
Vality's Bitter Coast & Ascadian Isles Addons (with BTB's patches)
Morrowind Graphics Extender (3.8.0, I stopped looking before they made XE)
These all work together perfectly (if installed correctly and in the proper order) and make for a more stable than vanilla game to boot!
That is the list that worked for me, so I backed it up and stuck to it... well they didn't so much work for me when I started with them, but they do now. The Graphics Extender setup is a hog on resources, my 2014 computer is the first machine I've owned that can actually handle the game at the settings I wanted. Definitely worth it though! (glamour shot attached)