... my concern using catalogues is they are databases, I'm familiar with the maintain required and concerned about corruption after 100's of hours of effort.......yes I know about backups but power failures et al corruptions happen
Okay, but understand this: LR's catalog is not a back-up of the files on your hard drive. But the catalog, or "database" as you call it, is a fact of life with LR. Besides being an awesome RAW converter, it is LR's ability to index a catalog as it does that makes the program such a powerful tool. You can only "edit" an image in LR if you import the file into LR. When you import a file into LR, reference to that file is written into the LR catalog. If you tag the file with keywords, those keywords are written into the catalog. If you make adjustments to the file in LR, those adjustments are written into the catalog. All of this is done so that LR can call up the information for future adjustments, edits, additions, deletions, etc, etc.
You have options for how the catalog works. So, what I'm suggesting is to understand how the LR catalog works; embrace it, love it. Get ahead of it now so that you can set up the catalog to do what you want it to do in the future.