I built a tool that allows you to review and delete duplicate photos: https://github.com/mtalcott/google-photos-deduper

I used it on my own library of ~70k photos to delete ~20k duplicates. Hope it can work for others too. There seems to be interest in this feature from Google Photos users, but it hasn't ever made its way into the product.