Some of that has to do with the fact that most game devs don't release modding tools like Bethesda, it's a lot harder to make overhaul mods. So that's why you mostly see reshaders and alterations to character models. But yeah, you check out any game, sort by most downloaded, and the top mods tend to be bug fixes, essential files for other mods to be able to work, and then the nudity mods.