CRI of lights is definitely a large factor in my purchasing these days. The muting, compressive response of some lights almost pains me at this point.

As this post's author noted white LEDs can be pretty solid. Bulbs that have a mix of white LEDs at various temperatures to be "bi-color" tend to be pretty solid as well. Its once you go towards RGB light bulbs that you tend to get a fairly iffy CRI.

I've referenced https://optimizeyourbiology.com/light-bulb-database and https://optimizeyourbiology.com/smart-light-database before when looking at bulbs but if anyone has a better resource, absolutely please drop a reply.

Consider looking at TM-30 as well as CRI, it's a more useful metric that better takes R9 into account. I've gotten a little bit obsessed with colour in the last few months, and have been buying different bulbs for the purpose of making DCP profiles and doing film scanning. What you want, specifically, is violet pumped LEDs. They're expensive and it seems like there are only a handful of them on the market, but they're a lot more balanced spectrally and tend to have low flicker (probably just because they're a premium product).

I'd be curious to understand exactly how CRI equates to the charts in this post!