Hi,
Let's suppose you are using a custom workflow which pulls a metadata value for each file, say some sort of GUID or productID- at the end of the day you are still relying on your end users to set and maintain that metadata, e.g. using the tools built into Photoshop or else Adobe Bridge. So there is a still a chance it won't be done correctly?
If the user is randomly changing the image name, it's better to educate the user or to understand why this is happening. If they rename the file, maybe it is better for SEO purposes?
If the filename is different on the upload, what impact does it have - extra storage required in the DAM? Perhaps the asset can be used again in the future. Or perhaps it muddies the search results? Shouldn't the onus be on the end user to delete unwanted assets.
In short, I am sure there is a technical solution, but would be good to understand if end users role here.
Mark