What do you think and how different it is than the experience of an average player ?
I absolutely have. My current work is my first time ever making en erotic game (and first time writing any story at all) so it was pretty bad in the beginning. The first time I was aroused by my own writing was a motivating moment lol. More recently, when I'm horny, sometimes I realize that I'd rather just read my own scenes than play/watch/read something else, which is also motivating (and results in my favorite scenes being the most well-edited).
I think it's natural if your target audience is people like yourself (and you're not writing to target a specific market for e.g. seeking better financial returns). If you're making the kind of game that you, yourself, would wish to play, then of course you should be getting aroused and using that as an initial measure of your work's quality; if you aren't getting aroused, be wary, though it may simply be the case that you've grown tired of it after working on it for so long.
IMO enjoying your own work is a good sign but it's not enough, because your initial mental conditions when you begin reading a scene is way different from a player's initial mental conditions.
In games where relationships and player-character bonding are relevant, there's the simple fact that you've possibly spent thousands of hours imagining and fleshing out your characters, so you're likely attached to them way more than a player who has only been with these characters for a handful of hours by the time they play whatever scene you're testing.
For text stuff, you're the one who wrote the scene, so you have a preexisting idea of what is happening - the positions, the movements, the emotions, the acts, the sounds, and so on. Thus when you read your words, you're always going to be combining the words with your existing mental image, whereas players only have the words to go off of.
So, just because you're able to get off to your stuff doesn't mean that a player, for whom ALL the imagery and whatnot must arise purely from the words, is going to have the same hot experience if your experience was relying upon ideas you had which weren't well evoked by the writing.
This can be somewhat mitigated by taking a break from your game for a while (months or more) and then returning once the scene isn't as fresh in your mind. It still won't match a new player's experience, but it'll be closer.
This applies to non-erotic stuff, too. Like, gameplay - you know the controls, you know the underlying mechanics, you know the intended way to play through levels, so when you playtest, your experience will differ from a regular player who knows none of what you do. If you're having fun playtesting, that's good, but you still need to make sure the player is actually getting into a mental headspace that allows them to have that fun experience.
I learned this idea originally from
You must be registered to see the links
.