In general, MBA degree is going to help you acquire new skills, and give a boost to your career. Most schools offer comparable MBA curriculum and for most people, it really doesn't matter where you get that degree.
However, exceptions exist depending on your future career plans.
If you just want a MBA degree to advance your career in your current industry or field, then what you would call an "average bschool" should not really matter (as long as that avg school is not named Univ of Phoenix or DeVry, Johnson & Wales, etc). Many people choose to attend mid tier MBA programs, because many of these regional programs are established in their respective regions. If you already have a FT job, and you are pursuing MBA degree for career advancement purposes, it really shouldn't matter whether the school you are targeting is nationally ranked or not. (even though people will argue otherwise because they are looking for best bang for the money invested in these degrees)
However, if you are a career switcher, and you expect more than what I've mentioned above from your MBA degree (in terms of ROI), then a degree from a ranked program is going to matter because those schools work very hard to establish themselves with recruiters, alumni, and the public in general (in terms of PR and recognition etc).
After all, when you are interviewing for a job, people are going to judge you based on what is on your resume and it is very easy for people to judge your talent and qualification based on your educational background. This happens often, and one of the many reasons why people are trying hard to get into one of these top ranked programs, is for this "benefit of doubt" that if a person graduated from X MBA program, then he or she is at least well rounded and etc.
Now that being said. You mentioned that you are looking to get a FT MBA degree from schools like Colorado State University, Oklahoma State University, Southern Methodist University in Dallas, etc for personal reasons. You also mentioned that you are looking at these programs because you can't move to the either coast. It's not that graduates from these programs can't find a job per say, but in terms of probability, the graduates of these programs might face bigger odds when looking for a job, and the job he or she ends up with, might not necessarily be the kind of fancy job that he/she expected to land with a MBA degree (it's a huge investment after all).
There are very good MBA programs in the midwest and central region of US. (Washington Univ of St. Louis, UT-Austin, Vanderbilt, etc comes to mind). Rather than giving up on your bschool aspirations, I suggest that you look for all the possibilities (in terms of where you can attend) before giving up.