I'm actually building something specifically for this -- it's called Trove. It's early but functional.
It's a desktop app (Windows, Linux, macOS) that acts as a local library manager. The idea is basically what you're describing: instead of staring at a folder of cryptically-named zip files, you get a proper library view with cover art, tags, version tracking, and one-click launching. Right now it's focused on AVNs but the plan is to expand to other game types over time.
Under the hood it syncs against a community-maintained catalog, so entries are kept up to date -- new versions, updated download links, changelogs. It doesn't host anything itself; it just indexes what's out there and fetches from the original sources (direct links, itch.io, MEGA, etc.).
Still in active development, but the core library management side is working. Happy to share more details.