Came back in here to post these! This guy's channel is great for technology nerds. I've always disliked bright white/cool white intense LED streetlights but couldn't put it into words as to why, but these videos explain it perfectly.
In layman's terms, traditional sodium streetlights do not illuminate as much as LED streetlights but create a wider spectrum of color for your eyes to interpret, adding greater contrast to what you see. They also give off a more natural looking light and softer shadows.
LED streetlights illuminate more but make what you see more of a dull wash with less contrast, in addition to their light looking unnatural and casting harsh shadows.