Overhead lights will always be more alerting due to their physical location regardless of how dim you can get them to be. Think about how alerting and energizing the sun is on a clear day when it's directly overhead. So, this is a natural reaction after living on this planet for thousands of years (at the very least).
So, when you're only using lights that are physically in a low location (like a desk lamp), the natural reaction to that will be similar to the reaction of the sun being at or near the horizon during sunset.
As you're probably thinking by now, yeah there is more to this than just the color temperature or brightness of the light. The higher the physical location of the light source, the more alerting it is.