Possibly a compromise could be an auto-collapse function where Photos shows it as a stack with the AI-proposed best pick on top, and an option to fan out and make your own judgment. That doesn't on its own fix the storage side, but it would be a small step from there to a one-click "trash everything from this stack other than the featured item.
Apple kind of does this with live photos, but it would be nice to have GPhotos able to figure it out as well after the fact, since we've all been doing the "take many pics of it just in case" thing since forever.
I could see this being done locally on a device and having a dis-or-dat style interface to quickly choose between competing photos.
But I always liked the idea of never having to worry about storage space and was willing to pay a premium for it.
I doubt that in the end I had more than 100 or 200 Gigabyte stored there, so Google would be a better deal for me even as a fairly heavy user, but I'd be willing to pay that premium for peace of mind.
If Backblaze can offer unlimited backup data for $6, I bet Google could make something similar work for a restricted domain like photos.
I pay £2.49/month for 200GB which would cover your usage for cheaper. Or you can 2TB for £7.99 which would mean you'd never have to think about storage.