All the properties I send and vet  have at least a 10% cap rate  and cash flow very heavily.

there are certain areas that are heavily section 8 and others that are not.  

It's heavily tiled for Section 8 / VASH recipients, but it will give you an idea. 

Everything else about Springfield is great and you get the opportunity to add a lot of value but just in my opinion the cons heavily outweigh the pros. 

In my 'perfect world' mind, I would be able to open that workbook and begin evaluating any given market because; a) First and foremost, it would be very user friendly b) It would be heavily automated through the use of formulas and/or macros that would provide easy to follow and understand prompts and solutions.c) Would be designed such that it would accept user entered data that, either as you went long or by the time you reached the end, you would receive flags of some sort that would provide a status of that market as a potential investment market (such as 'You're golden here!'

I plan to market pretty heavily to the college in hopes someone will like a furnished, trash and water paid rental for the school year.

Killeen economy is heavily dependent on Ft.

If you want to remain in this market, and you want a steady source of deals (as opposed to just stumbling across one once every year or two), then I think you're going to have to invest (heavily) in marketing.  

I am also very concerned about my property value declining as Scottsdale is such a big vacation destination and heavily investor focused.In a nutshell the HOA is requesting no vacation rentals (VR's), no subletting, no room renting, and a minimum term of 60 day rental terms.

David is correct, and I too heavily focus on investors and investment properties.