to go, or not to go

My Knight in Shining was told about a promotion opportunity at work that would take us far away from our comfy location here in Small City to a big city in the middle of nowhere where the cost of getting a comparable home would be more than 4x our current mortgage. As extra spice, there's almost a guarantee I would not be able to find comparable work because we are members of a marginalized race there, and because it's very much in the middle of nowhere and so expensive to live there, jobs are pretty much the most desirable commodity. Therefore they pay less, not more, than jobs here. In doing some research on things like cost of living and commute time and other basic quality of life questions, we discovered that things having to do with the natural world (hours of sunlight, climate, places to hike, etc) are wonderful, but the things having to do with people (economy, politics, traffic, etc) are . . . disgusting.
Basically if he were offered this and the promotion quadrupled his paycheck we'd be able to squeeze out something resembling our current lifestyle, and maybe in 5 years we'd be able to move back to a place with a more rational take on life and get on with the Big Plan of Kids. And in those five years I'd have sunshine support like I'd never had before, so the lack of garden or belly dance simultaneous with a lack of job might end up working in my favor. At least, it's a prospect I'm having a hard time ignoring now with winter setting in.
Would you trade in a pear tree in your front yard for an avocado tree in a large pot on a condominium deck? Hmmm. Will it actually get us closer to the goal? Ideally, we'd look at the salary they offer, notice that we could live on that in Big City, but decide to live that frugally here in Small City instead. I used to have frugal instincts. I need to find them again.