I have yet to see an interesting take on that succubus theme
Well they've been run through the same cultural mesh as vampires, elves, zombies etc.... They no longer possess the dreadful, existential danger that made them so fearsome, having been transformed into cosplaying sexpot cheerleaders.
The original succubus/incubus didn't have horns or a tail, but they were futanari with prodigious telepathic abilities, that would seduce members of both sexes by mentally projecting an image of a loved one, and could impregnate or be impregnated. They would fiercely protect the children ("cambion") born of these unions, even committing infanticide against their human half-siblings to ensure they received all subsequent love and attention.
The original succubus is Lilith, better known as the Second Angel of Evangelion. According to the Jewish Kabbalah, Adam and Lilith were originally a non binary couple formed by God at the same time, but Lilith was expelled from Eden for defying His will: basically God wanted her to be Adam's bottom while Lilith was an incorrigible top (I am not making this up). She later became associated with three other Succubi as seducer/He-Satan/sacred prostitutes, and with the archangel Samael. (Samael was God's butt boy. He planted the Tree of Knowledge in the Garden of Eden, "rode the serpent" thar enticed Eve into consuming the forbidden fruit, and is the reputed father of Cain by Eve.)