I'm very sorry, but currently there is no mod that adds new story content, new routes, or new sex positions into the game.
Those parts of the game are not moddable (at least for now).
For now, there are only two places where you can download community-made mods:
In the future, I do plan to upload some community mods to Nexus Mods as well. I already attempted to upload one there, but it didn’t pass moderation because the preview images were considered NSFW, even though many NSFW mods already exist on the platform for other NSFW games.
I will try again later with a non-NSFW preview.
📝 Edited: Nexus Mods banned MDRG. They don't allow anyone to upload any mods for games that focus on pornography. But for some reason, there are already approved mods for other porn games on their platform, and we don't even count those NSFW or pornographic mods for any games, especially those mods for Skyrim.
If you're looking for mods with specific themes or styles, feel free to tell me what you're interested in, and I can recommend something that fits your preferences.