CatDV does what you describe but there are more questions than answers with your worklfow. A good system integrator would likely do wonders pointing you in the right direction.
The good part is CatDV has a deep set of tools to help organize files with and/or with out a central database. Watch some of the videos especially Bryson’s 4 part demo. Contact us for a trial license if you want to take it for a test drive.