Improve the hints given by the enforce_home_region setting

**Is your feature request related to a problem? Please describe.**
There currently isn't a wide variety of hints given in the "Query has no home region" errors returned when the `enforce_home_region` session setting is on. This issue is opened to explore new types of hints for different query patterns. See comments in #102103.

**Describe the solution you'd like**
Examine the multi_region_remote_access_error test and find possible improvements to the hint messages. Maybe write new query variations and see if different hints would be more applicable.

Jira issue: CRDB-27325