🛠️ Repo: (Epic) Improve project management automation

[mark-wiemer]

Tooling Suggestion Checklist

• I have tried restarting my IDE and the issue persists.
• I have pulled the latest main branch of the repository.
• I have read and agree to Mocha's Code of Conduct and Contributing Guidelines
• I have searched for related issues and issues with the faq label, but none matched my issue.
• I want to provide a PR to resolve this

Overview

Overall, I as a maintainer have been struggling to keep my head above water with all the paperwork that goes into a project of this size. I want to automate a lot of this busy work so that it's done consistently and, most importantly, I don't have to do it!

Historically, I've had issues with manually rotating GitHub tokens to ensure that GitHub Actions workflows have consistent access to our issues, projects, etc. So one area of research will be finding ways to avoid GitHub tokens if possible (OIDC?) or at least sending alerts and clear rotation instructions ~7 days before token expiry.

Acceptance criteria for closing this issue isn't fully defined right now as I'm still researching, but wanted to start tracking these efforts in a more centralized place without creating a new label :)

Additional Info

No response

[hainenber]

#5613 probably falls into this epic, IMO