For me it just didn't last very long. It also gives off heat which will heat your tank water when it's on.
I also think the CFL will look better. It will for sure last longer. I'm no expert in light either but I am damn certain that the CFL will be the real winner.