On the topic of Visual Novels: I’d like to recommend basically everything from Winter Wolves Games that is tagged as RPG. The classic is of course Loren the Amazon Princess, but, to be honest, their writing has improved since then, so you might want to check out their newer Tales of Aravorn games, like Seasons of the Wolf. Also, Loren is really long, so if you don’t have a ton of time, the newer, shorter games might be a better choice.
A word of warning though, by Winter Wolves themselves: mastodon.social/