One smallpart of a nuclear powr plant, with clean energy, would take care of all these light bulbs and a shitload of electric BBQ grills.
LEDs are fine because they are cheap to run and last. The kicker is color temperature. There are enough studies to show that BLUE emissions are harmful to your retina (this also includes your LED monitor). So buy LED lamps with a color temp of 2500K (warm white in old florescent terminology).
LED lamps in the A pattern frequently are directional, so they are useless for table lamps where you want downlighting in the base direction.
I replaced the tubes in my kitchen 2x4 troffers with 40w equiv LEDs at 2500K. Simple to wire past the ballasts, no more changes!
LEDs suck for illuminating fine art. Halogens with all their problems will prevail for the spots.
Women may notice flicker with LEDs, as they do with florescent office lighting. Men can sometimes see it in their peripheral vision. Headache is the common complaint. It’s from the alternating current, 60HZ in the US, 50 in many other countries. Since LEDs run on DC, there may someday be LED lamps with capacitors which could be marketed to address this issue.
I replaced HID 400w lamps in my garage. You have to rewire past the ballast. Awesome, instant-on, and only 100w LED consumption. Downside is daylight color (5000K) which may change as more demand comes along. You can scrap the aluminum reflectors for better light dispersal. The loss of 2kw heat is noticeable in the winter.
Lastly I did a 3000 sf store. 85 2x4 drop-ins, 85w LED, 2500K. Studies also show people buy more under warm white lighting. Great savings, especially in the AC load, more than overcome winter heat gain.
No one needs to get on a ladder to change a screw-in lamp, BTW. Get an extension pole that comes with several different heads. Perfect for PARs, R30s, A, and CFLs. I used to put down an old blanket, but I have never dropped a lamp, even a heavy outdoor PAR150. They are sold everywhere.