£6 a pint, £199 a month for gym membership, £1,200 to rent a studio flat? The Guardian’s former North of England editor asks if the city she’s worked in for 12 years is changing for the better – or worse