Looking for photo organization software

Looking for some software to help organize my photos which are currently spread out across lots of random backups. Something that displays the metadata usefully and identifies identical photos would be a big help.

Does NOT need to sync to phone or anything, just need help sorting things into a navigable structure on my machine locally.