Hi Tayna.
A workflow should be able to action this but it might be a relatively big set of conditions. I’d suggest a workflow per condition potentially to keep it simplier. These get complicated if you want to include exeptions so as long as you have very clear and defined rules on the process and automation this is possible.
Depending on what HubSpot subscription you have you could also lean on custom coded workflows. Basically you can use an API to find and update assocaited records etc using a script.
Happy to help you solve this if you need a hand, we’ve set up similar for our company (We have 6 ownership fields… haha)