If you look around you can find some reviewers who will get into the details on the spectrum coverage, CRI and similar indices, and flicker at different brightness levels.

I think this might be the site I spent the most time on when I was last shopping for bulbs. I got a bunch of bulbs from IKEA of all places that work via zigbee and have really good light quality.

https://optimizeyourbiology.com/light-bulb-database