multitenant: increase tenant testing coverage of unit tests #138912
Description
The idea is to continue from where we left off in #76378
See the comments below for the current state of this issue,
Some sub-issues logged so far:
Jira issue: CRDB-46420