The focus of the light is key — by lighting the painting and not lighting the walls around it, that makes it pop a lot more than typically area lighting common in residential applications. Color temperature is also very important. Finally, in my case; my walls are painted a dark, lead-pipe grey so it makes the paintings really jump.
The brand of my lights is Wac Lighting controlled by Lutron dimmers in case you are interested. Color balanced LED. LED used to be inferior for galleries, but the tech has gotten very good (added benefit of running a lot cooler than the old halogen.)
Generally a higher CRI equals a higher quality light source. A halogen/incandescent lamp has a perfect score, 100. High end LED sources are usually in the range of 95-98, but that number can be gamed, which has lead to the creation of CQS.
https://blog.1000bulbs.com/home/is-color-quality-scale-bette...
I wouldn’t overthink it.. just as long as you stay out of the 4500K+ range (approaching daylight,) things will look great. The warmth of the 3600K range is great — anything less than that and the warmth of the light starts to affect color rendition, anything more and the light gets bluer and harsher.
Your eyes can be the guide. But having correctly focused light at the correct intensity (not too bright for instance) is key. There are use cases for daylight balance — if you are in a mixed light situation such as a windowed or skylight with abondant sunlight, you might consider going a little cooler on the color temperature — but again, use your eyes.
It can be really fun messing with lighting and art! Good luck.
Might be possible in a few decades, though.