Might I recommend 'Loren The Amazon Princess' off the 'Hella Yuri' list? That's one of my go to games when I'm feeling down. It's an RPG, but it uses Ren'Py and the mechanics are light enough that it feels close to a VN. It's not 100% yuri. You can pick your character's gender and also choose het and yaoi routes. It's quite fanservice-y but in a universal way (men and women get the same treatment) that I found almost sweet. It had me giggling rather than cringing, though of course, your mileage may vary. There are happy endings pretty much all over if you're worried about that.
The main reason I love it is that there are few characters I've enjoyed being as much as Elenor. She's the vulnerable party in most relationships, yet stubborn and prideful. I especially liked her romance with the older love interest, Karen. I believe the dev hosts a free demo on their website if you're unsure about what you're getting into.