Revamp build and test failure notification system

[gaiksaya]

Is your feature request related to a problem? Please describe

As of now, build and integration test failures are notified via GitHub issue based on CI failures.
There are few issues with this:

1. Its completely string based. For build failure, it searches for Error building ... string and creates issues for those components. Similarly for integration tests, it follows exit codes.
2. Even if the failure is due to CI glitch (agent nodes not coming up or windows being glicthy usually) it treats it as a component failure and creates the GH issue.
3. Integration test failure issues are not closed automatically. This was by design as the workflow runs are run separately for each distribution, platform and architecture. An enhancement to detect no labels and close the issue was not executed.

Describe the solution you'd like

We are indexing all the build, test and release data in opensearch-metrics cluster.
Use this data as the source of truth to create, update and close the GH issues rather than depending on the string and CI failures.

Describe alternatives you've considered

No response

Additional context

The scope of this issue is to refactor notification only. For flaky tests detection see #4171