Favor query plans with a home region using enforced properties for enforce_home_region

This issue is opened to investigate an idea from @DrewKimball mentioned during review of #106334.
Currently the `enforce_home_region` session setting will use adjusted distribution costs (see `LargeDistributeCostWithHomeRegion`) when the setting is enabled to adjust the cost of Scan and LookupJoin expressions.

An alternative approach could be to create a new property enforcer to restrict query plans to not be able to choose joins and scans without a home region. This would essentially move home region checking out of the execbuilder and push it to optimization time. If we are unable to find a query plan for a query during exploration, we would error out and report the query has no home region. One challenge may be, how to provide a proper hint to the user on how to adjust their query to make it satisfy the home region restriction. Currently, it is the inspection of the built memo that allows us to do that.

Jira issue: CRDB-30412