This hits the nail on the head with the potential problems I am facing too.
I’ve got everything well organised on a Finder level but if I ever have to relink a project in the future then Im also worried it will be too easy to get lost when trying to reconnect to redundant file names.
Did you have any luck developing a workflow or any system of batch renaming to deal with this?