The best solution is what @codyfrisch described here, have a dedicated account for automations and integrations. In the October update a new feature is mentioned to transfer ownership of integrations when deleting a user. Brand new - I did not test it yet - but it looks promissing.