If you want the best consider hetal halide
The spiral cf's are ok in larger sizes with pendant or batwing reflectors. There's a cheap 48W one and an expensive 125W one. They're very painful to look at, the 125 is almost impossible to look at.
The smaller ones are ok in places where you have say, an old reflector meant for 4 incandescent bulbs. They're a cheap way to do low light tanks.