Interesting. I live in a big MSA (Atlanta, which includes a lot of mostly rural counties). I've considered a role at Google, but currently work in a suburb and live further out from there. 1 hour to Atlanta proper without traffic, but still in the MSA according to the census. And I could move further out and still be in the MSA (like Heard County or Jasper County if you want to look at some examples).
Atlanta is still going to be a significantly lower pay band than premium plus (Bay Area/NYC), though. Tech salaries there aren't as high. The ideal play is to be far out in the boonies of a premium plus MSA, e.g. something like Dutchess County in upstate New York. The cost of living there is quite low but you'll still make the highest salary possible.
Interestingly, Seattle is only in the premium price tier, not the premium price tier. This is because there's no state income tax in Washington, so a lower salary goes a longer way. So it ends up being a wash even factoring in NY/CA state taxes. Because CA taxes are higher than NY (but not NYC taxes), your best bet is living in upstate NY (Long Island is outside of NYC too but it's eliminated because CoL is higher there).