I didn't know there will be sex scenes, this gonna be interesting (or not, I don't know yet, depends how they look like and what happens in there).
These likely need a skip options, certainly. Even if someone likes them, sometimes just needs to happen fast, I skip many cutscenes I like, in many games, after I watched them many times and don't need to watch them anymore, skip has same effect already.

But then again, I still wouldn't be against them, there can't be innovation without failures. I would need to think a lot how to make them, if I had to direct such scenes... Maybe like the one I remember from Witcher 2, Geralt and Triss in rose garden or bath. That was a beautiful place and that scene was just really fitting there.

As for wasting resources... could look like, if it's about scenes I would just skip. But then these kind of games seem boring to many, no offense, but dice & and stuff isn't what an action gamer or even a non-gamer would want. Just think for a moment from their perspective as well. Add a bit of color & tease, without turning it into "adult" content of course, and may become interesting and worth going through the "boring parts" to get a rewarding romance scene. Why don't attract more people to the smart parts of the game? Even if the main audience already likes it, more money will allow more games and with even more features, since all they are about cost as well.
I'm here for example just for the RPG part & story (that's part of RPG but still, one could role play on the go and invent stories, I won't).

There is always opposition when it comes to sex in games, even if "skip" is the default. The standards of our society are still like of a medieval cloister; rotten to the core, but still keeping the "façade" appearance of a "holy" institution. I remember the posts against the Witcher 1 "Sex" cards. Just silly. Things may need a proper packaging and implemented in a tasteful manner, but they need to be there, to allow life-like reactions.

More options are always better, if they are useful options. Many would like alternative ways of playing through games, other than just killing. Being a "murder hobo" is the golden standard, since crusades and before, but isn't better way than just sneaking through stealth, using diplomacy from friendly arguments to subtle mind control, and maybe now using that special charm "Casanova" or even being more subtle about it, like that happens in our real world.

How much graphics details for all these? I'm not making the game, but somehow I'm afraid that the most bloody killing scene would be "enjoyed" without any "skip" button, but even a mild sex scene would cause heart attacks. So I guess we don't want players dying during gaming and "skip" is needed, like those training wheels mounted parallel to the rear wheel of a bicycle that assist learners.