Not to mention the Color Rendering Index (CRI) metric Ra does not weigh the R9 (deep red) so many forms of lighting don't try to render it correctly to save costs.
Unfortunately, there isn't really a way for a consumer to know short of buying a spectrometer like my Sekonic C-800 Spectromaster.
For illustration, I have uploaded a few readings here, mostly flashlights, not LED bulbs: https://majid.info/images/reddit/spectro/
If you look at the Zebralight SC64c LE, for instance, it has an excellent Ra of 92, but only 75 for R9:
https://majid.info/images/reddit/spectro/ZL_SC64cLE/SC64cLE_...