I don't really care one way or the other. I haven't played a lot of VNs but of the ones I've played with H-scenes:
Katawa Shoujo, I can't think of a greater sin that playing this with the H-scenes turned off. Didn't even pop a boner during any of the scenes, I was to busy giggling and being really happy and shit.
Fate/Stay Night, sex scenes are completely unnecessary (and dumb) but serve really well as comedy. The game is already hilariously awkward and thank fuck they took that to the extreme with the sex lol.
That being said, I don't know if EVERY VN needs this stuff. Probably wouldn't mind if FSN didn't have any. Also it's kind of dumb that so many VNs seem to revolve around characters in high school and also have to have a disclaimer that everyone is 18. Come on, put 'em in college or something. TBH from what I've played so far these games have great stories but, not great writing*, and I think in order to write a sex scene that doesn't sound stupid you need to be a fucking fantastic writer.
*writing is kind of broad. I'm not talking about the way the story is told at all, just the way the words and sentences are pieced together. I guess I mean prose? I don't know, I'm an ignoramus. I would blame this on translation but even KS is bland in this regard.