But if programming is what you intend to bring as a founder - if it's simply a means to get the burning ideas out of your head and into a product, then there's a much smaller number of places where that will work: San Francisco, Seattle, New York. You need to be able to have coffee with a VC, meet with multiple co-founder options, do a tech meetup and also spend a sizable chunk of the day coding.
If you live near a small city, working that way is an impossibility. You'd have to go to the nearest big city to find that type of collaboration, and the trip will burn through all your coding time, and you still won't have the kind of quality selection that you'd get in NY or SF.
As you say, hacking the rent-salary ratio, which is what the article is about, should be a much smaller factor in how you decide where to live.