There's a lot of visual novel games out there and more are in the development phase.
I have many favorite, even one i dont even remember could be a favorite still when i remembered it.
Hakuoki all version is really nice. I bought them all and i dont regret spending my money.
But the one that is being etched on my mind is Beyond Eden, the story is just heartwrenching and full of angst between the MC and the current lord of the house(first son).
Doppelganger dawn of the breaking souls is an old one, but still amazing nonetheless. The story full of twist and also TWISTED CHARACTERS, heartbreaking storyline, good and bad ending worth to be experienced.
Fantasia series also made by doppelganger developer, is a good fantasy game. Recommended to try it. Both are old games so dont expect flashy graphics.
Freakquency is also a good sci fi slash fantasy in modern world. I also loved it so much but i dont really feel that attached to the sequel. This is also an old game if i remember correctly.
Nightshade, ninja romance. The betrayal, the plot twist, its nice but not the best but good nonetheless.
And lets not get started on steam prison, you just need to play it no matter what okay?
Blind Griffin was okay, you can try playing it if you are free. Honestly if the game story is more lengthier and explored more or maybe has a few sequel series, it might be one of the best.