Bethesda
Bethesda games are known for requiring a lot of mods in order to fix their technical problems and improve them.
Fallout
The Best of Times - Mod for Fallout: Tale Of Two Wastelands(A mod that converts Fallout 3 to the New Vegas engine, as well as making both linked to one another)
Viva New Vegas - For Fallout New Vegas
The Midnight Ride - For Fallout 4
Personal review: I Have found this guide to be very useful.
The Elder Scrolls
Glory of Cyrodiil - Oblivion (Archive.org copy)Hasn't been updated since 2023, and in fact, doesn't even have a domain anymore. Not sure why.
A Dragonborn's Fate - Skyrim Special EditionDiscontinued due to conflict about which version to support.