In my opinion, I don’t really hate it completely. However, I don’t like that certain areas use them for residential streets as opposed to only being used on main roads and busier routes. For residential streets, I prefer 3000K and 2700K LED street lighting.

Personally I don't mind it. But I agree with you that LED street lights should be 3000K or 2700K for residential areas.

Overall, I like 4000K for streets...it reminds me of DX MV from my childhood...only problem is that its glary! But I have to agree, nowadays 3000K is better for residential streets. 

I have no issue with it, it's functional, not entirely obtrusive and (in my opinion) is nice to be under if you want to look at something. All LED lights in the city I live in are 4000k, including the one down the street from my house. As long as the luminaire design doesn't have too much glare.

4000K is sure better than the 5000K and 6500K crap that some went with early on.  Sadly, I have yet to see a 3000K parking lot or street light that looks good.  Just too dim.  Hope to see a higher output/lumen one someday and then we can see.  I've been replacing a lot of 150-400W HPS & MH parking lot fixtures with 4000K LED and the color looks great, and the area is much better lit now vs what HPS and even MH had. 

I should add, I haven't seen a 3000k lit street before. I'm used to 4000k and I have no issues with the colour, just certain fixtures.

To me, 4000k streetlights are good for highways, and are right between the coziness of 3000k and the brightness of 6000k. Unfortunately, I have only experienced these on highways, as many streets here use a cold 6500k.

4000K looks nice on highways, arterial roads, and downtown shopping districts IMO.

Quieter side streets and residential neighbourhoods look better with 3000K.

Toronto uses 3000K in their LED gumballs and they make a pretty good stand in for the old incandescent gumballs that were in use until the mid 90s.