Seems like the problem is in your attachment to your flat. Fixer-upper houses in the countryside are basically cheaper than a year's one-bedroom rent in the Bay Area. It's all a question of trade-offs. Would you rather
a) have a soul-crushing job and a nice flat or
b) live happily, but in the Mid-West?