But it's a dry heat: 'American Oasis' delves into how five cities successfully emerged from the deserts of the Southwest