There have been long discussions on this subject. While file duplicate finders were the most talked about, there was nothing found that meet all your requirements.
--> But your question set off ALARMS. It appears you are about to fall for a TRAP. The trap is to consolidate all your files to one place and one copy.
This is usually when folk learn why we never whittle our files to one place and one copy. It's far too unsafe.
After years of working on multiple computers (a family of Macs at home, Windows at school and work) I've accumulated TBs of data and backups and duplicates and versions.
I'm now working away from home ALL the time, I never know when I'm going to need or want any files and I don't want to be carrying 10-12 USB HDDs with me so I have setup a NAS that I can access anywhere at anytime.
My real issue comes with the data migration from multiple sources, removing duplicates and compiling/merging everything into a single location. It will take me years to do this manually. I have been using Singlemizer from the App Store going on a year to reduce duplicate photos and it works a treat, but removing duplicates is only half the job.
Can anyone suggest any Apps or Programs out there that will do this for me or at least make this whole process much faster?