So what do these in-between places offer, besides the cost of living? You tend to get off the beaten path nature where the cost of living in the city means you can actually afford a vacation home (Minneapolis and Chicago get the great lakes northern coast lines), funky college towns that grew some tech talent for various reasons and are college-y and by great natural areas (old Bozeman, old Austin, old Boulder, current Ft. Collins), and lastly I'd say genuine immigrant population and their subcultures, and food to match. There are legitimate Little Italys out there, but they just left NYC because it's too expensive (or also refugee resettlement plans). Minneapolis, Syracuse, parts of Tennessee, parts of TX that aren't Austin, etc.
You throw a tech salary into that mix, and it becomes really fascinating.