Time on my hands - Photograph Organization

So I have a list of things I’ll get to when I have time. One of them has been to organize a few generations of photos. My immediate problem is that I have digital photographs stored over several disks and on line locations. Some are from parents. Some are from my kids.

I don’t need them in a single location, but that would be nice.
It would be nice to cull out actual duplicate photos.

There are several products that claim to do this automatically. Has anyone had a good experience doing something like this and what did you do?

The only one I have tried leaned very heavily on the JFIF data to organize, and if you have a heterogeneous camera and user sourcing, that is less likely to work well. No idea what a recent state of the art tool would be.