This one is complicated. The natural response of your eye in well-lit conditions is known as the photopic response.

When the light goes down a bit, your eye switches to Mesopic vision, essentially generating and using a good number of rods to supplement the cones. Your cones have very good color sensitivity, but are inefficient and bad in the dark. Rods have bad color, but great sensitivity. Mesopic vision "lasts" until about the light level of a full moon.
After mesopic vision comes Scotopic vision which is purely from your rods. Colors desaturate and you loose red response almost completely, with a peak sensitivity at a teal color.

A color temperature greater than approximately 7000K-8000K is cooler than your eye is used to seeing and will appear unnaturally blue. In dark conditions you may not be able to distinguish it well from a temperature of 5500K (daylight). Camera noise and a loss of color saturation in the dark is also an important factor. A temperature lower than about 2500K is mostly producing energy in the infrared. Such an object would appear strikingly red, perhaps unnaturally so.
Many objects, sources, etc, do not produce black body curves. CFLs and LEDs typically do not, while incandescent bulbs produce somewhat modified ones.
I hope this sufficiently answers your question.