Simplify the release process

[savente93]

Kind of request

Changing existing functionality

Enhancement Description

While we have documentation on how the release process goes, a lot can go wrong in between the steps which then need laborious fixes. It would be good to have a "two click" solution for releasing that also has proper protections around it. The release process imo would consist of two phases (hence two click solution):

1. One (part of) the workflow should create each of the artifacts, prepare them for release and run any automated tests on them that we can, while leaving them available for manual inspection if necessary
2. After the release owner has inspected and approved the artifacts/workflows the release (creating tags, uploading the artifacts, publishing the new versions to our channels) should happen automatically.

This way we can significantly cut down on mistakes that happen during the release itself.

Use case

No response

Additional Context

No response