Test workflows shouldn't fail with CodeQL recommendations

[RikuVirtanen]

Workflows should not fail when CodeQL has recommendations but rather put a comment to the PR. Warnings and Errors should always fail the workflow.