I work (in an office, not remote, mind you) at a tech company in the Research Triangle area of North Carolina. Most of the people I know also work in tech companies. In fact, outside of state government and the school systems, the major employers around here are all tech companies and research universities. You can easily have an entire career in tech, working in-person, in good jobs doing cool stuff. And the cost of living around here is a tiny fraction of what you'd pay in the SF/NY/LA/Seattle.
If you want to live in [big overpriced city] because you like said big overpriced city, feel free to do so. But HN really needs to get over this ridiculous idea that big, overpriced cities are the only place to have a tech career.