Cleaning up thousands of duplicate records in Salesforce is a nightmare ...

Messy code in a complex org usually leads to technical debt ...