E2E test: block on SCM test failures

What does this MR do and why?

Consolidates the following MRs that were raised by #441362 (closed) :

• !144410 (closed)
• !144412 (closed) - !144408 (closed) <-- this was removed as it failed in the first pipeline
• !144407 (closed)
• !144409 (closed)