Which light to use when painting?

I share the same experience, until now only day light has given me full satisfaction, but it is very inconvenient (changes, available only during the day...). Even with the right color, it is still necessary to work under very good lighting conditions otherwise one can have a very bad surprise when exposed under gallery conditions, which are usually quite intense. Some awkward brushstrokes, local colordisgraceful saturations can be unseen in low light conditions but become very visible under bright light conditions.

I have tried a lot of what exists on the market (incandescent with filter), photo professional adjustable temperature+intensity LED lighting... never being fully satisfied and still searching. One of the problem I faced is that dark colors tend to brighten (black is no longer black !) under intense good quality artificial light conditions (1000 Lux, CRI>95), whereas the same phenomena does not appear when under daylight even with higher light intensity (>1500lux). I assume it is linked to the directionality of the artificial light (intense at a precise angle) but it is just an assumption, I would be curious if someone noticed the same and the reason for that...