If you are looking for a fictional take, check out "The Water Knife" by Paolo Bacigalupi: https://www.amazon.com/Water-Knife-Paolo-Bacigalupi/dp/08041...

Eerily relevant.

Eerily prescient.

Basically, my attitude is look at a place before a lot of humans got there that had technology that could bring water and climate control.

That's probably what it's going to go back to at some point. You can only buck mother nature for so long.