I work in a medium-sized(1.5k employees but with a rather small electronics engineering team) aerospace company using Altium only for Schematics/PCB and we've found that Altium Vault is absolutely not worth the money.
Almost all the features of the vaults, if not all, can just as well be managed using Subversion(which Altium supports quite nicely on it's own, actually) and maybe a few scripts.
If the company already has reasonable infrastructure(i.e. subversion already there, carefully managed repositories with differentiated access rights etc., CIFS shares set up via policies on all computers so everyone uses the same absolute paths...) then all you need is to spend a little time on setting everything up for an ideal work enviroment with Subversion, while Vaults force you to pay perpetually and it's not cheap at all.
Also, Altium Vaults do not integrate well with other software or databases, like our own stock and suppliers database, it's much easier to set everything up if all your Altium Parts are simply in a Database Library that you can control. Same goes with mechanical and cable design(we use E3 for hydraulics and cable harness plans and Autodesk products for all mechanical stuff) - it just integrates more seamless if you have everything tailored to your specific needs, especially since Altium and Autodesk, especially if you have competent IT people to get the databases up and running.