A long looong time ago, my gf found one called Saya no Uta. It has H-Scenes (only a few I think), but its pretty well written. I wasn't as big on it as she was, but that started my adventure down dark mystery/psychological horror VN. To this day its her favorite, though.
I can't remember everything I played and enjoyed (I wish I could but its so long ago now). I actually had to search for my favorite one because I constantly forget it. Its more dark mystery psychological with only a small amount of horror scenes, but its called DIVI-DEAD.
Again, it has H-Scenes, but thats not the sole premise. There are so many clues and endings. It has a college campus map, so being in certain places at certain times changes everything. I believe you get a time limit of like... 1 in game week to get the best ending? It goes off the rails a bit here and there, but I have fond, albeit blurry memories of it. It feels so dim and unsettling for such an old game. So good.
I've also seen that CHAOS;HEAD has good reviews, but I don't know much about it- only that I've seen the name before and I think it got an anime a long time ago. I'll keep looking and trying to remember more.
Actually just remembered one. Its called Another. It had a fairly popular anime release, but if you haven't seen it I recommend that one as well. And, of course, there's the well known Doki-Doki Literature Club.
I've been pondering Nobara for a while, tbh. GE Proton is already my goto and most trusted runner, and GloriousEggroll is the mind behind Nobara (though I'm unsure if they're the sole dev or not).
From what I've seen, it just sets you up for gaming right out of the box with minimal effort. The post-install welcome menu looks clean. It has everything you need to set up and install in one menu.