So I have to ask you, if/when you do face the sexual content, does it ruin it for you? Or is it a sort of a payoff in itself too?
I wouldn't necessarily call it not a fetish. I certainly enjoy playing a virgin character - and when they lose their virginity, I reload, and go down a different route, most of the time. It's certainly a fetish, alongside the other things. Though you aren't wrong to compare it to suspense and similar feelings. I'd still argue it's... more base than that. Just about that context.
As for the sexual encounters, it depends on the game itself. For some games, it's absolutely a let down. I mentioned it in that previous post of mine, about how I can spend too much time on games that don't really have all that much going for them - because I'm not actively seeking out participation in them. In the sexual scenes, that is. So in my mind, when I'm playing these various... life sims, etc, "this is great! Who knows what might happen! Oh, something could happen here, oh, this sort of event could happen there, oh, I could have an encounter like that, oh, the park, I bet X, Y, and Z" could happen there. As I play, I'm excited, I'm building up my character, in my mind I've roleplayed, I have her thoughts, her character, etc, in my head.
And over time... maybe nothing happens. Or maybe something happens and its disappointing. And I'll start forcefully "poking" the game. Not because I need, or am desperate to see, the sexual content. But because I'm curious as to what's actually there. And often, when I start poking around, it's just "... oh." A multitude of scenes that... devolve instantly into various themes I don't like ("you stuck your dick in me and now I crave cock," etc), or just writing I don't enjoy, or just simply a lack of any real, actual content. So where, previously, I was enjoying myself, enjoying the idea of "hey, all around me, there's stuff that may or may not happen - and that's exciting," I'm realizing "actually, there's nothing happening unless I go down specific routes and force it to happen." And that's where the disappointment comes in.
To speak on the opposite of disappointment, the payoff comes in when it's earned, when its done well, and when I "lose" to something that feels worthy. When it feels like I didn't have to force myself down a route. When I legitimately just played the game, made my choices, and then ended up in a situation that I was actively trying to avoid, it's the best. And then, in the perfect situation, I get to load, make a different choice, keep going, and keep experiencing that all over again.
To branch off, perhaps, I also do text roleplay. I both GM, and am GMed for at times (Game Master - controlling not just one character, but an entire world that the opposite player interacts with). And regardless of what side of the "table" I'm on, what I want more than anything is not for us to get to a certain point of a story ("hey let's do an RP where a girl gets raped"), but to play through a story where things are simply possible. Where things might happen. Or they might not - it's up to the players, up to the choices that are made. And I'll be equally happy with "okay, at the end of her vacation, she goes home happy" or things coming to a darker end. What I enjoy is that throughout the roleplay, there was the possibility that either could happen - and I never could be completely certain which path things would go down. When I'm looking for a game of a similar theme, I'm looking for that same feeling, ideally. One of "hey, things might happen. Things might not. But either are possible. And it all depends on what story I make with my own choices."
I think that's maybe a key distinction. The idea that the story is made via your own choices. That's what a "maiden" route often can give a feeling of. Just at least a token nod of "hey, you don't have to." The idea that I'm not being told "no, this is the story - sex happens, and that's what you get, and that's what you'll like." I get to choose. I get to play a part in my character's fate. And in that choice lies all the difference.