best type of bulb in glass ceiling fixture
LEDs are completely the win.  That is the way to go.  They last 30 years (probably longer, realistically, no one knows). You can get them in any color temperature or CRI you want, you don't need to get harsh LED if you don't want to.  

CFL is dead.   It was only ever a "gap technology" to temporarily gain efficiency until LED manufacturing was able to catch up.  

Incandescents will be around for a long time, in improved forms such as halogen.  They aren't that efficient, they get hot, and they burn out.  Only use them if you have an engineering requirement for incandescents specifically (such as a doghouse warmer, or oven light).