At a large, busy campground with lot going on, I enjoy the various lighting at campsites. Funny that people mentioned those "star lights". We were just camping last week at a busy family campground and my wife kept saying that the stars looked odd. Took us a long time to figure out that it was coming from one of those laser star projectors at a neighboring campsite. That was the first time we had seen that! Very cool!
We walked over, the neighbors welcomed us, we checked out the lights, talked, laughed, and just had a good time.
Rope lights also seem to work well. I like when they are put underneath the camper, and on the ground around the outer edges of the awning. Lights up the campsite in a cool way.
I agree that at a quiet, "woodsy" campground a lot of lighting effects would be annoying. But at a large busy campground, I find it interesting and cool how people setup different lights.