Migrate tests owned by CAR from SConstruct to Bazel.

This ticket includes all unit tests that do not directly or indirectly depend on sharding_test_fixture_common, as that dependency has dependencies on other teams.

Benchmarks (env.Benchmark(...) / *_bm targets) will also be handled separately as there is no support for building them with Bazel yet.