I had a 4000K LED bulb. It was way too bluish for indoor use (except in the garage). I do not think this was actually the color temperature but rather the tint of the light. From what I have seen, LED light seems to have very "bluish" tint at anything higher than 3000K. I know it's not the actual color temperature because I have a 96 CRI 4000K LED emitter and do not notice this problem at all (apparently the tint problem goes away at really high CRI). I think it has to do with the blue spike in the spectrum, if you look at a spectral graph of a 4000K LED.
4000K is not blue. It is a sunny bright, slightly warm, white. But put a 4000K LED bulb in a lamp in your living room and it just looks unnaturally bluish. You might disagree with me, that's fine, just describing my observations. Another factor may be that things look bluer at lower lighting levels at night, the so-called Purkinje effect. Turn on an incandescent bulb in the daytime in a room with a window. You may be surprised at how reddish-orange the light looks.
I don't agree with your observations, I just disagree with you not being completely clear in how those observations were made and what it means. I also disagree with reading 1/2 or 1/4 of a Wikipedia article and then posting things here as fact when you don't really understand them, i.e. the Purkinje effect which applied to lighting occurs at mesopic lighting levels, which are not lighting levels we typically use in a home.
I sit under 4000K, 80(min) CRI LEDs all the time. Nope, no blue tint. Of course, I am adapted to this light so why would I see any blue tint when they sit fairly close to the blackbody. If you are seeing blue tint on a 4000K bulb, either your bulb isn't really 4000K or more likely, it is just one bulb in a light environment that is predominantly a lower CCT. Light a room exclusively with 4000K bulbs and sit in their for 30+ minutes then tell me it has a blue tint.
The fact that an incandescent bulb looks reddish-orange in the prescience of bright sunlight has nothing to do with the Purkinje effect. That is basic white balancing of the visual system. When you have adapted to 5000-6000K, then 2700K looks reddish-orange ..... similar to how if you adapt to bright 2700K, then introduce a 4000K bulb, it is going to look "blueish" .....
CRI -- ONLY matters when you illuminate something, not when you look at it directly by the way and that something you illuminate better not be white or again, you are just looking at the bulb directly somewhat.
Semiman
p.s. but what the heck does this have to do with 4Flow ... no need to hijack every thread to try to make it look like you are an expert on lighting and color ... since obviously ....