I miss the night looking like night, the ultra-harsh white LEDs used in street lights are trying to mimic daylight which is the last thing you want to do at night in my opinion. The old sodium lights might have had unnatural colour rendering (or in the case of low-pressure entirely monochromatic amber) but this was a small price to pay for warm outdoor lighting. There's no reason SOX and SON bulbs can't be approximated more efficiently with LEDs, we could have the economic benefits of LEDs without the horrible side-effects of cheap and nasty ones.
I'm not sure where a previously sensible industry decided ultra-harsh daylight bulbs were warranted literally everywhere, in the past harsh white halide bulbs coexisted with sodium ones for decades and there was always guidance on when to use gentle sodium versus harsh halide lights. Apparently everything needs to be as harsh as possible these days, damn the institutional knowledge. I'm not anti-LED but I'm anti-'lots of blue spectral content at night' regardless of the source.