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.
Bob