I think the majority of mods I see for games make them harder, often in stupid or bullshit ways. But the most popular ones are usually blatant cheats or coomer mods (and I have nothing against coomer mods).

Every Elder scrolls game has mods to remove level scaling but they all make the game worse. I agree with complaints about level scaling in general but no ES games were designed for pre-scripted levels. So the modders just haphazardly spread level 50 enemies all over the starting areas, turning it into a quicksave simulator.

Generally I go for mods that remove inventory headaches or onerous encumbrance systems. I have probably spent literal years of life playing inventory tetris and I am just done with it now.