It's interesting- I think most people would rather get the higher salary regardless of cost-of-living or spending power. Some kind of gratification to their self-worth or something.
Keep in mind, though, that at least part of the reason that some places have a higher cost-of-living is that it's more desirable to live there. I'd certainly rather live in Boston than Houston.