As much as it pains me to agree with people plugging their own games, between them they have made 2 of my favourites.
Depraved Awakening is coming along fantastic. Story is good, characters are great and the sex scenes are good. Obvious downside being if you don't like noir'esque (that's a word ... well it is now) stories then you may not like this but it is well worth a try. The thread for it is pretty fun too although I don't think there are any women left that haven't been claimed .... you can have the stripper, she's hot for a few scenes and then she's very, very cold.
Sanguine rose has started off great. Only limited sex scenes but that doesn't matter as per your post. It is very story focused but the writing is genuinely good and the characters are really well done .... The only bad thing I can say is we've been speculating on romance arcs when the plot is one of those where everyone could end up dead if the dev so wishes. I know that's not a bad thing but it does mean the plot is unpredictable and for a guy that likes to know what's happening it makes my brain hurt from speculating.
Love and Submission is another I play, story is coming along nicely but the selling point is pretty much similar to Sanguine in that it's unpredictable. We ended the last update on a cliffhanger because the dev hates us (not really, well, maybe) with more to come but the characters are well done and it's worth playing.
Starship Inanna is one i've followed for a while and although I do enjoy it the story has jumped around a bit.
Anything by Tlero and Meortze. Dreaming with Elsa, Redemption for Jessika, Finding Miranda and Saving Chloe are all stories within one big main plot and are really well done. Pandora (not on this site for some reason) is another good one. Elsa and Jessika were the 2 VN's I played that led me here so these guys were my introduction to H games.
Dreaming of Dana is one I enjoy but it has a character in there some people don't like. It's recently been finished so all story arcs are now done.
Sister Lust isn't anything we haven't seen before but the characters are all really well done.
Blooming Love is a lesbian romance story. I really like this one it's one of those heartwarming tales and I am a sucker for a bit of romance.
My Sister My Roommate is another well written one. It's more comedy focused but it is genuinely funny including a crazy vegan ... well, i've never met a sane one.
Edit - I forgot Spaced Out. How I forgot I have no idea, I wrote a walkthrough for it. It's got a pretty decent story and characters along with other fun things such as solar panel polishing.
Roundscape Adorevia. I have no idea how I forgot this either. My favourite RPGM game in that it's an actual RPG with decent characters, story and gameplay. It's like an old Final Fantasy with occasional fucking. Well, regular fucking.