A potentially useful UI alert for content editors would be if you upload a media asset that already exists (ie, has the same md5 sha, based on contents of the file, as another file) then it could prompt you “Would you like to use this other file that looks the same instead?”.
Another approach (likely more challenging) could be in the media asset manager or via API allow you to filter to find duplicates and then merge all those duplicates to use a single asset. It would change all records pointing to that media asset to the one single version.