So here is an interesting problem, if you write a sex scene for a game, then you want to make it really hot and sexy right? Well if you make it sexy, then it will get you all hot, and that is actually a bit distracting. Then if you write several sex scenes in a row, then that is even more distracting. The more the game falls towards being a porn type game, the worse the problem is. Though it also goes the other way. Since the human brain is wired to like sex, if you do a really hot sex scene, then you will want to write more sex scenes because your brain likes that. So if it is a story heavy game, you can be tempted to add more sex stuff, even if you are trying to focus on the story. That happens some times too.
Actually that is why I get distracted with random new games some times. Because I get an idea for something that would be really sexy, then want to write a lot of hot sex scenes for that. Though I go off to do that without thinking about the long term structure that would be best for such a game.