Detroit ranks #2 on CNNMoney's list of the Most Stressed Out Cities, but the Motor City may be poised for a comeback.