There's a lot of big cities that have horrible mass transit period let alone airport service. How about all of Florida, for one. TPA is my home airport and it's a beautiful airport but there's no significant mass transit service. Likewise for Orlando and Miami.

I also fly into DTW a lot, same story there.