Overall, my thoughts are negative about it. As humans, we can complain about the aesthetic of the night sky being lost; the night sky that shaped so much of our history (religion, architecture, literature, navigation -- the list goes on), only to be replaced by a permanent twilight if you live in a highly affected urban or suburban setting. I'm glad I live far enough from the shit that I can see the night sky, although I acknowledge its not 100% perfect. You'll notice that most people don't give a second thought to it/don't have an opinion or care.
Most of my negative thoughts on it stem from its effects on wildlife. Birds, insects, nocturnal mammals (like bats), marine life. In one way or another it contributes negatively to them all. One example being; birds using the night sky as a navigational aid during migration. Once they enter the urban hellscape, the night sky is lost. The birds see lit up high rises instead of stars, and become dazzled, exhausted, and often collide with these buildings and die. This is a simplified example, but it does happen, with the consequences resulting in millions of dead migrating birds each year.