Where in upstate? You should look up Duncan Crary, who lives in Troy, NY. He did a ton of podcasts with James Howard Kunstler, and has a newer one called a Small American City. It is about this very topic of revitalizing small American cities. There is also Ithaca, NY.