If we're talking gods of lust and destruction, the webnovel 'Renegade Immortal' has to be the first thing that pops to mind. The character Wang Lin, while not precisely a god of lust, embodies a path of destruction born from profound loss and twisted desire that's incredibly tragic. His entire cultivation journey is a spiral into colder, more absolute annihilation, and the origins of that are heartbreaking. It's less about erotic lust and more about an insatiable, world-consuming hunger for power and control to fill a void, which I find a more interesting interpretation anyway.
Another one that comes to mind is the 'Fate' series' take on the goddess Ishtar, though she's more chaotic and destructive with her passions. The lore around Mesopotamian gods in general, filtered through modern anime and game adaptations, often paints them as forces of primal chaos whose 'lust' is for conflict and upheaval. I remember a side story in some fan translation that really fleshed out that kind of backstory—how they became that way out of betrayal or isolation. Makes them feel less like cartoon villains and more like broken entities.