Where are you seeing these? Is this industrial/commercial suppliers?
https://www.housebeautiful.com/shopping/a31139492/ge-relax-l...
It is a good start and I know know its wroth looking, so think you.
Standard LEDs bulbs are bright white, almost bluish, and yes "bright but not illuminating" describes them well. I feel many modern car headlights have the same issue.
The human eye doesn't focus the blue end of the spectrum very well.
Lots of companies sell cheap crappy A19 E26 base 5000K lamps, that doesn’t make them the ‘standard’.
https://www.thesmarthomehookup.com/25-soft-white-led-light-b...
Nothing on the box really means anything, so many bulbs claim high CRI and everything but in reality have terrible spectrum. So you can only go off of actual real life testing from a third party.