ci: review required jobs in `tests` workflow

[anakin87]

Currently, our tests workflow defines a trigger-catch-all job (name: Tests completed), which blocks merging PRs with failing/not executed jobs.

It includes the following jobs

haystack/.github/workflows/tests.yml

Lines 485 to 487 in 06512a8

	- integration-tests-linux
	- integration-tests-macos
	- integration-tests-windows

We should review this list to include other mandatory jobs.

In fact, a recent PR (#9119) was approved and auto-merged even if lint job failed.