Replace cleanup with t.Cleanup in workhorse tests

What does this MR do and why?

Replace cleanup with t.Cleanup in workhorse tests.

In many places we return a cleanup function and defer its execution in order to cleanup after tests. This MR refactors it to use T.Cleanup as it has been added to Go.

See #433440 (closed) for more details.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.