Investment in the arts has rocketed in Manchester recently. But are we wasting our money, asks Rupert Christiansen