I'm not going to say much on the topic of the Crew, but I do know plenty of people who purchase season tickets and travel to Crew matches from Toledo, Cleveland, Akron, Youngstown, Kentucky, Cincinnati, Dayton, Indianapolis, Pittsburgh. It stretches outside the state. Those are the hardcore soccer fans. The attendance problem probably relies more heavily on the people within the Columbus area than those outside the city. Although you need both to contribute in some sort of way.
I have no relation to Columbus either besides the many new soccer friends I've met at Crew Stadium over the years either in the stands, Nordecke, or in the parking lot tailgating. Ever since my first visit to Crew stadium back in either '01 or '02. I remember watching the supporters section from across the stadium and telling myself, "I want to be there". I remember when Brian McBride, Frankie Hejduk, Cunningham's first stint with Columbus. Some good times. I've made many trips to Crew Stadium carpooling with new friends I met from Cleveland and Youngstown or Crew fans here in Akron. I'd love to have an MLS club or even an USL Pro or NASL club in the NE Ohio area, but until that day, I'll follow the Crew as my MLS Club, wishing the best to former Akron players.
EDIT: I just came across this piece tonight and thought it was worth sharing a good read. Soccer's Heavy Boredom