According to a new study, some cities have seen a significant deterioration in residents' personal financial outlooks.