Felt I should mention a really great indie visual novel style game called Slay the Princess. It isn't really unknown as its sitting at 97% positive on steam with nearly 24,000 reviews, but still worth mentioning here. Not usually my style of game as I can't usually just sit down and basically read a story much anymore. Blame ARPGs for frying my brain I guess.
But the writing, voice acting, setting, art, and music are all amazing in this game. Seems like a silly premise that might have a "haha!" style fourth wall twist but... it's a lot more than you'd think. It's got some slight horror elements, psychological horror, romance, and a lot of introspection on your part as the player. I'd say more but I'd really like people to go into it blind if at all possible.
I say if you're looking for a great story, you can't go wrong with this.
https://store.steampowered.com/app/1989270/Slay_the_Princess__The_Pristine_Cut/ (https://store.steampowered.com/app/1989270/Slay_the_Princess__The_Pristine_Cut/)