I have several of these in the US:
PHX
DEN
LAS
DTW

I have spent some time in Atlanta, but not in a long time, so lately I just know ATL the airport and not Atlanta the place (going there this weekend, though, by car). Also, commuting to Minneapolis each week and not having a car or much time to explore, I know Minneapolis basically as downtown and MSP airport.