I haven't made a game (yet), but I used to write erotica for a living and... yeah. Honestly, it was kinda frustrating, because as soon as I'd get into a flow state, the image of the scene in my head would get more and more vivid until I couldn't concentrate, which would break the flow state and stop my work. Then I'd be off for an hour or two of personal time before I could even think of doing any more real work.
But I have a hair-trigger libido, so I'm a bit weird in that regard.