I don’t think it’s fair to dismiss all visual novels as worse than Key stories without even reading them. H-scenes don’t always detract from a story, in fact, I’d implore you to read something like Cross Channel whose tone (to me) was greatly aided by those scenes. Although I don’t think you’d enjoy it from what you’ve said thus far.
This is getting away from the main topic, though. I guess the point is that there aren’t a ton of visual novels that fit such a tight criteria so it’s probably in your best interest to try not to let a short scene completely ruin the rest of a great story. It’s just an unfortunate part about the medium.