As AI and cloud demand explode, developers are looking for the safest and smartest places to build. These U.S. markets have the edge, but for very different reasons.