I think what you describe in Kill off CI jobs | github-feedback should already be possible: Canceling a workflow - GitHub Docs
Note however that "Write access to the repository is required to perform these steps.", so the PR author usually can't cancel the workflow themselves...