Test the feasibility of running SCT manager tests triggered from siren-tests framework

Some time ago, some attempts to "marry" siren-tests and SCT have been already done which resulted in siren longevity tests where the cluster is created in Cloud and subjected to SCT nemesises.

Currently, these tests are disabled - not clear in which state they are and how much effort is required to bring them back to life.

The scope of this task is:

at first, bring back to live existing tests and run any of them;
run any Manager SCT test (preferable for Manager restore operation) from siren.

scylladb / scylla-manager

Test the feasibility of running SCT manager tests triggered from siren-tests framework #4118