Fluorescent lights work fine for starting seeds or clones, and may generate enough light for leafy greens and herbs. For flowering plants, LED and high-intensity grow lights produce better results. The two types of high-intensity lights differ in where they're strongest on the color spectrum, which affects how your plants grow.
Metal halide lights emit bluish-white light that stimulates lush green growth. High-pressure sodium bulbs emit light concentrated in the orange/red spectrum, which plants need for flowering and fruiting.
Incandescent lights are too hot for use in indoor gardens.