Add error reporting for update workflow

[kenodegard]

Checklist

• I added a descriptive title
• I searched open requests and couldn't find a duplicate

What is the idea?

Improve error tracking of failures in the update workflow.

Why is this needed?

We recently had an issue with the update workflow ceasing to work due to the actions/cache deprecation. This forced us to manually push updates to all projects using the update workflow. Unfortunately since the workflow is decentralized it has been not the easiest to figure out which repos need fixing since the workflow failures are not reported anywhere. Instead select users (those who originally committed (?) the update workflow) get notifications of the workflow failing. Other with we need to manually check the workflow state in the actions tab per repository.

What should happen?

Let's add a step to auto open an issue here when failures occur so it'll be easier to track and address issues.

Additional Context

No response