I've never found sex scenes in games appealing. First of all, there's rarely any build up to them. If there is, it's just sitting there, listening to an NPC talking about themseves for 10 minutes and selecting the "good" answer to gain "affinity points" and proceed with the dialogue.

Then you get to the sex scene, and it's either fade to black immediately (hopefully), or two uncanny valley dolls touching each other for a few seconds.

After the sex scene, the partner becomes another NPC, sitting there doing nothing, having completed their purpose. So inspiring.