TrueSteamAchievements has this (in Easy Achievements). Source: 7 months ago

It does happen perfected games get new achievements added. Maybe that's what happened to your missing game? It's a real drag to make a separate list to compare Steam's list to, but maybe it's worthwhile signing up for something like True Steam Achievements if it's important to you. Source: over 1 year ago

OK looks like they've been picked up by truesteamachievements.com and some people have them unlocked. Source: almost 2 years ago

A other way would also be to go on: https://truesteamachievements.com/. Source: almost 2 years ago

Whether 100%'ing a specific game is worth it or not depends entirely on your preferences. I wouldn't put too much focus on achievements unless it brings you joy. I can't give you recommendations since I don't know your tastes. I'd simply pick a game you like. This website can help you track your progress, and it also has guides for most achievements. Source: almost 2 years ago

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: 7 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: 12 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: 12 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: 12 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: about 1 year ago