Our home has many can-light ceiling fixtures. We replaced the original incandescent bulbs with CFL in many of them and noticed some cost savings on our electric bill for several years. More recently we added some LED style.
Bulb costs, duration of use, and total cost of use are some of the quantities tabulated in the chart below from wikipedia. I don’t know how recent are the values. But, they illustrate the cost savings with LED. With LED costs coming down, the savings is improving.
The main problem with an incandescent bulb is that about 75% of the energy needed to operate it is wasted as heat energy to the surroundings. Only about 25% goes toward making light energy. The CFL and LED bulbs convert a much greater fraction of their operating energy into light energy. As a result, they need less electrical energy to produce the same light output as an incandescent.