Water is a bit odd in that it's ridiculously cheap even where it's scarce, so the financial incentive to build massive water-diversion projects isn't all that great absent a specific political or governmental imperative. It's also dubious that it's worth diverting water to places that are naturally scarce (or where wasteful policies have drawn down aquifers and other groundwater sources). Pushing the carrying capacity of a region well beyond its natural levels is a fraught enterprise, especially if the regions haven't shown themselves to be particularly good at managing their current water stocks.
Personally, I'm betting that in 20 years the Great Lakes rust belt is going to be enjoying a hell of a resurgence.