Is NI good for astronomy or stargazing

Thinking about buying a telescope but not sure if it is even worth it if I can’t see anything, rarely see stars. If so does anyone know any good locations.

Edit: thanks for all the advice folks appreciate it!!