The future is almost certainly going to be indoor farming, climate controlled systems and mass produced lab grown foods (eg: algae, insects), so access to fresh water is going to be a bigger bottleneck than say, nice weather or soil types. Soil can be trucked in from arid or inhospitable regions. Food can be grown in vats.

Tolerable power structures are directly related to the resources on hand and pressure on those resources.

Fresh water is what future wars will be fought over. Perhaps coastal cities will up their desalination game, who knows.