The most beautiful sky I ever saw was when I was stationed in southern England, driving down a curvey B-road (are there C-roads? This was practically a path) in the country. I stopped because it was pitch-black out. I got out and sat on my car & waited for my eyes to adjust. The winter stars were so bright, and so many! The next night I brought my beloved to see. We felt blessed.
This is proof to me that light pollution isn't a real problem. Southern England is one of the most densely populated areas in the world, but a little journey off the beaten path, and you can see the sky fine still.
I've made my mind up, if you want to stargaze, go somewhere remote. Lighting is incredibley important to safety, both personal and road, in urban areas.