You can still buy 100 watt light bulbs. They are sold under "rough service" as a specialty item, but still available. Nothing keeps a basement compartment warm as easily and safely as a plain old incandescent bulb.
For everything else, I went with cheap LEDs, and it wasn't anything to do with energy payback time. The first is that when boondocking, they use a lot less battery than incandescent 12 volt bulbs. The second is that they last a lot longer, so fewer replacements are needed. I could have gone with warm white light, but the LEDs I bought for cheap from Taiwan do the job well.
As for CFLs, there isn't anything wrong with them, and they are quite good at the watt/lumen ratio. LEDs are a little bit for most things, and a LED usually takes drops a lot better than CFLs. Of course, there is a price premium for this.