How bright would the night sky be if we were closer to the centre of the Milky Way?

Would Earth being closer to the galactic core be a stargazer's dream, or nightmare?