Revenge of the Goddess

A failed rebellion in the Celestial Realm gets the Goddess of Domination and Lust stripped of her memories and dumped in the human world with nothing to show for it. She gets the memories back eventually; the divine powers stay gone. What's left is a goddess with a grudge and no way to enforce it.

That's the setup: a fallen deity rebuilding herself from zero while plotting to get back what was taken from her, tangled up with whatever love and conspiracy she runs into along the way among the humans she now has to live among.

You play the male protagonist caught in her orbit as she works her way back to power using whatever's on hand, human bodies included. It runs as an RPG with sandbox structure, so progress comes from exploring, talking to the right people, and letting her domination take its usual physical forms rather than from grinding combat for its own sake.