Yes, and for many players, having sex is the goal of the whole story.
Especially for the "full save please" faction. That's not me, I am one who enjoys the ride
And that " the goal of the whole story" is the reason why the Thanos thingy was a bad example. The movie wasn't written as way to make Tanos turn into dust. That was just the outcome. Of course he had to be defeated on way or another, unpretentious action movies are just like that. Would he have been defeated differently (and for example still live), the movie would have been just as good. And Infinity War? Thanos had not been defeated at all and it was by far the better movie. Him turning to dust was most definitly not the highlight of the movies, all the good stuff happened earlier.
If you need to see people shag in a VN to enjoy it, that's ok of course.
Just comparing it with a movie without ending, that's just off. A different ending or different content ... that would be a better comparison. Movie with or without brains exploding, something like that.
I don't see how this helps your case. By this criteria, Duality is also not one of the good ones, because a game where the MC doesn't have sex at all certainly can't continue the story after that happened.
Duality hasn't reached that point yet, that is true. As a consequence it's too early to judge this aspect, only time will tell (or not).
It doesn't have much of a story tbh, it's very basic. But it has some nice ideas and I hope that it will develop in a good direction.
A rushed sex scene at the beginning would still leave this game without ending, I would still be sad that it seems to be over.
Seeing people shag is by far easier than finding a decent naughty story, that's why it's only of second interest to me. If I want to see people bang, I have plenty of places to go.
I started playing these games when they had no renders at all and tbh many of the old text AIF games had better story and by far better gameplay (You really should play "Moist" if you get the chance). The new games I usually really just play for the visuals, to get some good shots.
There are exceptions of course. Being a DIK is written very well, reading through the "Hell Week" chapter was a whole lot of fun.