It sounds like what everyone in this thread needs is a database file system. This was always my favorite proposed feature of Windows Longhorn that never made the cut. Almost 2 decades later and Microsoft's latest OS still doesn't have this feature.
I wrote about what I perceived as deficiencies of hierarchical file systems, and proposed an alternative organization based on tags and hashes. It was discussed on Hacker News last week and many years ago.
