Enhance test running

There are several issues. One is the original issue. But there's also a problem where if your module doesn't have a functional test, the kernel test won't have a db created by the functional and the tests will fail.

Another problem, there isn't a good way from looking at the test run to know what version of drupal core or even the db driver that was picked.

Lastly, there's no composer caching from one build to another. Simply adding some caching and the builds drop from 2:15 to 1:40 for the first composer install pass.

Let's improve all those things.

Original report: https://gitlab.com/drupalspoons/migrate_source_csv/-/jobs/569975321 is failing on sqlite because the hostname isn't included in the sqlite db url. It thinks that the 'sites' is the hostname, then passes along default/files/.sqlite, which it can't find. Then the test fails.