The power supply is the weak point in LED room lighting. The best power supply for LEDs is switch-mode PWM, high frequency, and with thermal management designed by an engineer who understands therodynamics.
Unfortunately all those things are expensive so you rarely find such bulbs in the cheap bin at Home Depot.
It's very unfortunate that our electric codes are based primarily on incandescent lighting. If we were designing electricity from scratch, we'd probably be set up with 240v 3 phase AC for big loads (ovens, heaters etc) and 48v DC for lighting and most electronics. Requiring every device to have its own rectifier is a lot less efficient than putting a single good rectifier in a central location.
Where could one find such things if they could afford it?
Bulbs are actually a very bad form factor for LEDs, because they concentrate two heat-generating components - the PSU and LEDs - into a small chassis. LED tape with a separate power supply is probably the best solution that's not a full-custom DC light fixture.