Voice of experience here
I have two different types of screw-in CF bulbs on 10 gallon tanks.
The first is the 19 watt spiral flourescent from Home Depot, ~$8 each, in a daylight spectrum, ~6000K. Two of them gives you 38 watts over 10 gallons -- if they will fit. The spiral is rather wide and so you can do it if you remove the reflectors from the hood. With 3.8wpg you can do this pretty easily, IMO, you can afford to lose a bit of reflection.
The second bulb is a 10 watt U-tube compact flourescent from Walmart pet department, ~$5 each. Also daylight spectrum and the U-shape allows it to fit into the normal incandescent socket easily with no modifications necessary. Two of these gives you 20 watts over 10 gallons. With a small tank, I think you get a lot of spillage through the glass of the tank and so 2.0 wpg is OK but not great.
I run Hagen CO2 units on both tanks. On the higher light one it is necessary due to the light, on the bare bottom Q tank (planted driftwood only) it just keeps the pH in line with the main tanks in case I need to move a fish.