With mega-galleries heading west and a dynamic local scene, the city is realising its market potential