Big cities used to be the land of opportunity for most people. But with changes in work, some economists are wondering: Are cities overrated?