I have noticed since being a member here that sodium lighting, be it LPS or HPS, never took off in the US to the same extent as it did here. There, MV always seemed to be the preferred light source.
Here, it was probably the other way around. For residential streets, and minor roads, mercury was used quite a lot; the estate where my mother lived, and where I spent many years, was lit by 80W MV post tops, and there was one right outside my bedroom window, I deeply regret never having taken a photo of it

But like everywhere else, it got "upgraded" and the area was never the same again.
For major roads and motorways, LPS ruled supreme. In fact, the first ever motorway lighting of all in the UK was installed on the M1 between London and Luton in 1971, and consisted of no less than 1200 140W linear sodium lamps

Later, SOX was used extensively, and there are still some sections of motorways lit by them, mostly around the outer London area, which we were both surprised and very pleased to encounter on our last trip there.
Personally, I have always preferred LPS, a 45W SOI/H was the first sodium lamp I ever collected, and I still have it to this day. It is now almost EOL, but still lights valiantly, or it did the last time I tried it, I think now that we have a NOS example of the same type of lamp, it will be put into retirement and displayed

HPS..? Yes, I like it, it's not quite the same as low pressure sodium, but it's still sodium, and although colour temperatures and shades vary far more than they do with LPS, they are still very pleasant to me, especially when out and driving. We have lots of HPS lamps, one I like a lot was received not long ago in a trade with Patrick, and you can see the wonderful amber/gold glow from it.