I'm trying to remember the name of a fantasy book I read a while back (10 years ago).
There was a male protagonist who was some kind of "chosen one" and a succubus-type character who was after his "seed" for some grand purpose.
I think the book ended with the succubus having sex with him and acquiring said genetic material. I think it had a mostly realistic setting with fantasy elements interspersed.
- at one point the succubus tries to set up a meeting with the guy at a motel, don't remember if it actually happened
- definitely some explicit steamy parts