Cleaning duplicate photos inside Lightroom Classic and Capture One catalogs without breaking them

Disclosure: I'm the developer of Folio Refresh, the Mac app this post is about. Most duplicate photo...