In most marketing you see those before and after shots. You will also you see a spectrograph of what the filter blocks vs full spectrum light. What you won't see is a spectrographic image of the filter vs actual light pollution sources. Well I'm gonna fix that, and show why we say what we do when it come to
Your typical Neodymium based LPS filters vs
Full spectrum (almost but not quite, it's the moon)
Good ol' halogen floods found on many homes and buildings
A nice unshielded Sodium street light
Mercury Vapor street/barn lamp (most of my neighbors have these as porch lights on the back of their house)
It looks like multiple images made the forum unhappy. So see the following posts
Now while I do not show fluorescent strip mall lights, and some of the other types, you get the idea. I also did not show what far more aggressive LPS filters look like. Those cut large sections out of the spectrum and cause a very noticeable drop in brightness and color shift. The make for poor viewing filter and poor imaging filters. So when you read "use a petrol filter", or "don't bother", there's a good reason for this. About the only pro filter comment you do tend to read is "takes the edge off", which is true.
Gear Used
Canon T3
660 grating (My apologizes to the spectra folks. I know you guys can do far better, but all I had was stripped CD spectrograph I made for educational/fun purposes)
A mix of LPS filters from cheap to $$$. Not going to say what's what, as the results where not significantly different when run through the grating. About the only big difference was AR coating or not, and the price.