Thank you both, very insightful!
I’ll look into adding LTO to the solution, have been pondering with it for a while but as hdd costs are coming down I’m not sure wether it’s not overkill.
I’ve looked into Neofinder and DiskCatalogMaker, so far I can’t decide which is better, most important for me is that the catalogs are stable and stay readable and don’t get corrupted.