Yeah, it does help to have a clear shot to see the moon and stars with the telescope. Trees and streetlights do put a damper on that.
What’s neat is to aim the scope at a spot that looks blank. Look and there are a gazillion stars in view.
I imagine in space, where there’s no atmosphere, it must be an amazing sight.
You don't have to imagine. Search for imagery from the Hubble telescope.