The Visual Novel Database VS FreeToGame

You could also try vndb, it’s very thorough in cataloguing even super-obscure visual novels and the search/tag feature is pretty robust. Good luck finding this game! Source: 5 months ago

You can also go to vndb.org/ , click on "visual novel," and rank by popularity or rating to see what others VNs fans in general like. Source: 10 months ago

Vndb.org is a great source to find out what has, hasn't, or is in the process of being translated. In this case, it looks like there has been no fan translations into English. While the search feature takes some learning to use efficiently, there's a myriad of ways to find games with unofficial patches. There are also other threads on this sub about using translation tools on your phone or computer to play... Source: 10 months ago

I took a look through vndb.org with the tags you provided and I think it could be Cafe Rouge - even the release date checks out, At the bottom are a few pictures, you can try comparing to your memory. There seems to be a remake with the same name on Steam aswell. Source: 10 months ago

Vndb.org is your friend. There was an unfinished text-based translation to read alongside the Switch game. You can find what was translated here before the project was dropped. Source: 11 months ago

Oh also there is freetogame.com tons of free modern games (sad most require steam). Source: almost 3 years ago