Atlanta looks good on paper. It always does. But actually being in the city tells me a different story.
That said, I think only Atlanta, NYC, Chicago, or Boston could absorb the extra demand for skilled employees without sucking the wind out of the other local businesses' sails. The Texan cities could, too, but I don't think Amazon will go there, for some reason.
If Amazon plopped down in Chattanooga or Harrisburg, or even Indianapolis or Detroit, it would exhaust the local talent pool immediately, and cause a local inflation bubble.