The Photos app has a delicates option - not that I want to piss on your parade but the functionality is already present? Or am I missing something?
Select some photos and then select merge. The pop up that follows will let you merge only the exact duplicates.
So you can first merge all your exact duplicates, and then when that is done manually review the visually similar matches.