roachtest,roachbench: explicitly test and benchmark all supported cloud provider storage classes

Currently, most of our nightly tests use the local SSD offerings of each of the major cloud providers.

To confirm basic correctness, and understand the expected performance of CRDB when used with various storage classes, one or more repeatable tests and benchmarks are required. The results of the latter should be made available on roachdash. The frequency of weekly is probably a good starting point.

Some ideas:
- Write heavy KV tests / benchmarks (i.e. most / all of the kv0 tests)
- There are also some AC tests that stress writes and have a pass-fail outcome:
- `admission_control_disk_bandwidth_overload.go`
- `admission_control_elastic_io.go`
- `admission_control_intent_resolution.go`
- `admission_control_snapshot_overload_io.go`

Jira issue: CRDB-50642