I've got a couple of ideas rattling around in my head at the moment. I thought I'd try and get them written down.
The first one goes back in some ways to when I was working on SSG. At the time I thought I'd like to create a scene where one woman was restrained in the middle of a large room while five or six guys took turns to have sex with her. Willingly? Unwillingly? It would be difficult to tell which. The only thing you could say for sure was that she never got a moments peace. She always had the undivided attention of at least one of the men.
The rest of the guys would stand around watching the action, maybe get a beer or two, perhaps make some unkind remarks about the woman. Every now and then a shift would change and some of the worn out men would be replaced by fresher ones.
And .... that's about as far as it went. A nice show piece, if a pain in the arse to script and debug, but how to fit it into a story?
Recently I was reminded of the idea, and I wondered:
Supposing that there was a Goddess of Sex who was going to destroy the world. Probably not intentionally; she just wants everyone to orgasm so hard that their brains melt and their hearts explode. She doesn't understand biological imitations, not having any herself. She just wants to take that moment of ultimate fulfillment and amplify it to the maximum for every sexual creature in the world.
Supposing that long, long ago some mad wizard summoned this entity to Tamriel knowing full well what she would do, and that the inevitable band of heroes arrived too late to prevent the summoning.
Suppose the Goodess' strength is also her weakness. That the only way to stop her from building up the energy needed for her orgasmic apocalypse was to keep her either in a state of orgasm or distracted by her own arousal.
And, going back to the scene I described at the start: supposing the woman at the center of the room is the Goodess, and the men are the descendants of those original heroes.
In an odd way, this is an act of Worship.
Now let's mix it up a little more: Ages pass. Red Mountain explodes. Winterhold sinks beneath the waves. The sect is isolated and its members grow old. Their act of worship requires a certain degree of vigour, one they increasingly struggle to provide.
What can be done? Well, new worshipers need to be recruited obviously. But no one can be spare to find the recruits; not for any length of time at least. Although maybe they could recruit an agent. Someone to go and find suitable recruits. Someone like the Dragonborn.
Of course, your ideal candidates would be men with insatiable appetites who weren't too concerned about matters of consenuality. You have to wonder where you'd look for such people. And, if they did agree to help, what they might ask of the PC in return.