Seconding Rimworld, but even without mods it is an amazing game with easily 1k+ hours of gametime. My favorite mods are QoL mods, or ones that add additional flavor to my colonists. If I could only pick a single mod to install, ever, it would be Common Sense.
Outside of Bethesda and Minecraft, the other one that comes to mind is The Sims. More of a niche following, but for those that love deleting pool ladders, mods are necessary for happiness, flavor, and adding actual challenge.
It's exhausting. This is why I try to kick my own butt into getting it over with as soon as possible.
Otherwise it continues to haunt me like a leech.
insert is this ADHD meme