In my experience modding every popular game to death, the most beloved and generally popular overhaul mods make the game significantly harder or more complex.

Factorio: Bob's mods, Angel's mods

Minecraft: Literally every tech mod, most magic

Skyrim: Requiem

Fallout 4: Horizon