Man, this topic takes me back. Years ago I stumbled onto 'The Dream Hunter' by Shana Abé, which isn't straight-up erotica but has this incredibly heavy, lush atmosphere where the line between dreaming and waking desire gets totally blurred. The tension is less about explicit scenes and more about the psychological surrender—the idea of being known in your most vulnerable state, of desires playing out in a space where consequence feels suspended. It’s a gothic-tinged fantasy that got under my skin.
For something more contemporary and squarely in the genre, Kit Rocha’s 'Beyond Surrender' has a subplot that handles somnophilia with surprising care, framing it within established trust and post-apocalyptic power dynamics. The fantasy element isn’t about violation, but about accessing a different level of intimacy, which I think is where the real psychological meat is. The tension comes from the characters navigating that outside of the dreamspace afterwards.
Honestly, a lot of the best exploration I’ve found isn’t in full-length novels but in short stories or serials on platforms like Kindle Vella, where writers seem freer to dwell on the internal monologue and the haunting, obsessive quality of the fantasy without padding it into a conventional plot.