Once the cost of living is factored in, workers can get a bigger bang for their buck in smaller metro areas