Hi James
I am in the same industry, and I have had the same question as you. To be honest, there is no ideal system out there, that has exactly what we need, however i’ve spend 100+ hours finding solution.
If you are interested, we can do a teams and discuss our findings, and maybe make an article for others to use with best practicies
jakub