It is what it is. Despite the growth of Columbus and Huntsville, not many Americans think of those cities as large and successful. Cleveland and Cincinnati are both smaller than Columbus, but I'll bet if you asked most folks to name a city in Ohio, Columbus would not be the response much of the time.
We do have other players on the Buffalo stage. JoAnn Falletta has landed the Philharmonic its first legitimate recording contract in a long time, and the University brings in a big name or two each year (look out for the Dalai Lama in 2006; that's large-scale). But are those "brand-makers?" No. Neither is an oversized retail store or a casino. (Is there a city left in America without a casino within suburb range?) NFL football, though, gives a city instant recognition.
As far as the other city you mentioned--San Antonio--why else are they fighting so hard for the Saints? Are all those blue-and-silver-wearing Texans all of the sudden diehard Saints fans? Nope. It's about the recognition.