Mods suggested to me by Anon

Quest Expansion Mods:

Quests Are in Skyrim
Nilheim - Misc Quest Expansion
The Only Cure - Quest Expansion
Infiltration - Quest Expansion
The Heart of Dibella - Quest Expansion
Paarthurnax - Quest Expansion
Simple Fishing Overhaul
Caught Red Handed
College of Winterhold Quest Expansion
House of Horrors Quest Expansion
The Innocence Lost Quest Expansion
Face Sculptor Expanded
Thieves Guild Alternative Endings
Finding Derkeethus
Defeat the Dragon Cult
Cult of the World Eater
The Whispering Door Quest Expansion
Mephala's Curse - Whispering Door Quest Expansion
Mehrune's Dagon Shrines Unlocked - Pieces of the Past
AFDI - Aetherium Forge Destroys Items
Beothiah's Calling - Alternative Questline
At Your Own Pace
Redeeming Fultheim
Bounty Preview
Headhunter
More to do in Soul Carin

Quest Mods (most are by Nirnwraith whose really good at making them):

Death Approaches
It Came From Akavir
The Devil's in the Details
Above All Else - Lovecraft Inspired Quest
A Friend in Mead - Quest Mod
Once We Were Here - Quest Mod
Before the End - Quest Mod
The Breathing Abyss - Lovecraft Inspired Mod
Behind and Beyond - Quest Mod
Bark and Bite - Witcher Inspired Quest
The Divine Question - Quest Mod
Memorable Stories
A Dizzying Fall
A Good Death
Final Farewell
Calling the Watchmaker
Whispers of the Depths
A Conversation
Blood and Grit
Depths of the Soul
Mysteries of the Dwemer
Painted Torment
The Serpent's Covenant
The Price of Art
The Hunt For the Spectre
There is No Umbra
Hunter's Dreams
Lost Heritage - Bloodborne Inspired Quest
Fortune's Tradehouse (buggy)
Revealing Rune
Return Aegisbane
Merida's Order (+ Vigilant Synergy Patch if you have Vigilant)
Unfaltered Virtue
Bethlor's Sister (uses AI)
Frozen in Time (uses AI)
Heart of the Reach

DLC Size Quest Mods

Vigilant (and its English patches)
Unslaad SE (and its English patches)
Dac0da (and its English patches)
Heart of the Reach
Beyond Reach
Wrymstooth
Sirenroot
Faction Pitfighter and Faction Pitfighter: Revamped
Project AHO (make sure you grab the ESM file tag in the optinal downloads. Also download the start where you want patch and the bugfix and improvement patch)
Carved Brink (grab the ESM file tag and the unofficial carved brink patch)

More Roleplaying / Choice

Alternative Perspective - Alternative Start
Alternative Perspective - Voiced Addon
New Beginnings - Lights Out Alternative Routes
Mistwatch Ending - More Options
Sensible Brides - Based on Speechcraft Not Level
Timing is Everything
After the Civil War - Siege Damage Repairs
Riverwood Trader Is A Mess
More To Say
Misc Dialogue Edits
More Dialogue Options
Andrealphus Scene Tweaks
Wait I Know You - Forcegreet Tweak
Simply Knock (+ Simply Knock SKSE64 DLL. If you don't have the proper patch for your game, you WILL CTD on launch)
Pumping Iron - Dynamic Muscle Growth
The Dragonborn Dreams
The Dragonborn Dreams addons - no buffs and more dreams
Adopt Helgi Ghost
Hearthfire Multiple Adoptions
Mythos of Skyrim - Immersive Artifact Description
Canis Hysteris - The Werewolf Disease
Kynareth replaces Talos - Civil War Consequences
Honed Metal
Ulfric...Tullius..Give Me a Break
Potema Minion's Fixlet
Immersive Speech Dialouges
Harvest Your Blood For Septimus

NPC Line Expansions

Dialouge Tweak - Eorlund Gray Mane and Civil War Quartermasters
Bandit Lines Expansions
Civil War Lines Expansion
Forsworn and Thalmor Lines Expansion
Brawl Lines Expansion and Fixes
Falmer Servant Lines Expansion
Carriage and Stables Dialogue Expansions
Guard Dialogue Expansions
Guardstalk
Extended Guard Dialouge
Extended Bandit Dialouge
Denizens of Morthal - Dialogue and Character Expander
Finding Helgi and Laelette
Dremora Lines Expansion
NPCs react to Invisibility
NPCs react to Frenzy
NPCs react to Necromancy (and more)
Taarie's Dialouge Fix
Respect for the Archmage
Respect for the Legate
Scared of Shootings - NPCs react to aiming bows
Improved College Entry
Soldier of Stendarr
Indecent Exposure - Immersive Naked Reactions
True Teacher Durneheviir
City Bag Checks
Alchemical Appraisal Services
Vampire Lines Expansion

Some gameplay / overhauls I use

Press E To Heal Followers
Simply Order Summons
Swiftly Order Squad
Take a Peek - New Stealth Mechanics
Soul Taker
Pickpocket Reset
Mum's The Word NG
Sanctified Stolen Goods
Pick up the bones BOS

For Vampires, I use

Dark Destiny - Become a Vampire Unwillingly
Seeking the Cure - A Rising At Dawn Quest Overhaul
A Forlorn Hope - An Addon for Seeking the Cure
Vampire Nightmares
Better Vampires (but some people prefer Sancrosact instead. It really comes down to preference)

For Magic

Sorcerer A Staff and Scroll Overhaul
Mysticism
FleshFx
Use Telekensis on Traps
No Force for Illusion Spells
Blood Magic Costs Health
Bloodmoon (really all of the mods this guy makes are good imo)
Ancient Blood Magic II
Dynamic Magic Modification Framework
Skill Based Charge Time
Maintained Magic
Unattuned Immersive Magic Failures
Liminal Portals
Loss of Focus - Spell Interruption
Rainmaker - For Pluviophiles

Finally for combat, I recommend

Precision
Precision Creatures
NPCs Take Cover - Smarter Anti-Cheese AI
Don't Stay in the Water - NPC Water AI Fix
Dismembering Framework
Stagger Effect Fix
Comprehensive First Person Animation overhaul
Disable Draugr Idle Taunts
Blade and Blunt
Modern Combat AI (this basically rolls back some nerfs made in Blade and Blunt to make enemies even more aggressive, load after Blade and Blunt)
Parrying RPG (not parrying, simply makes it so that weapons recoil upon impact instead of clipping through them harmlessly)
Bows Can Break
Attacks Interrupt Bows
Smart NPCs use potions
Paulicius Poison Block
Fantasy Environmental Effects
Next Gen Decapitations
Resistances and Weaknesses
Crosshair Aligned Crossbow
Improved Camera

Basically, you can't fix the combat with fancy animations, dodges, or fancy parries. You simply want to improve the foundation of what's already there.
Fantasy Environmental Effects and Resistances and Weaknesses, gives each enemy strengths and weaknesses that can be exploited like in DnD or Dragon's Dogma. For example, Ghosts are immune to mundane weapons, but weak to silver.
Improved Camera makes it so you can see you arms and your torso in first person, which lends to more immersion both in and out of combat
Paulicius rewards you for using your shield by allowing you to block poisionous strikes if your shield is raised.
Next Gen Decapitations, Dismembering Framework, Simple Block Sparks, Stagger Effect Fix, and Precision add some much needed impact to the combat. The lengths of the weapons now feel distinctive, the stagger effects are correct from a physics standpoint, metal clashing against metal creates sparks, and you can literally see you weapon tearing through your opponents. Optional hitstops from Precision also represents the irl momentum lost when two objects collide.

Attacks interrupt bows and Bows can break adds some much needed depth and stakes to ranged combat. You can now punish NPC Archers by quickly closing in and then attacking them, preventing them from shooting you. Likewise, NPCs can close in on you and destroy your bow if you're positioning is bad.
Smart NPCs means enemy NPCs will actually use potions to heal, allowing them to stay in combat for longer.