I kept seeing the following problem with several different LED lights we were installing until I found one that was better: Take your phone and take a video of the lights when on (normal framerate should be enough, try slow-motion for further investing). Most lights I got from the local hardware store were flickering quite visibly. And I'm pretty sure it's a design insufficiency of the adaptor electronics attached to it, not the LEDs themselves. If I were to guess I'd say most of them probably go the simple path of cutting off the negative half of the AC cycle and feeding the rest directly, without a decent low-pass filter to the LEDs.

What worked reasonably well for me, was getting a normal DC power supply and a few LED strips (with fairly dense and higher power LEDs) and installed that in a room. That light feels pretty satisfying to me.

All that being said, I don't like anything even remotely close to daylight level ambience when I am working on a computer screen; the custom lighting I set up is for other living areas.