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

Another thing you may want to talk to an optometrist about, especially if your photophobia causes headaches or migraines, is the FL-41 coating for glasses which filters out blue wavelengths that tend to be more triggering of sensitivities.

It made a big difference for me just with the lightest tint. Feels like glare reduction. The darkest one looks like the apocalypse, though, can’t recommend it unless you actually need that much blue block.

Phillips has "eyecomfort" bulbs, I have a set that adjust color temperature as you dim them