Asking about what lights are best is like asking someone what's their favorite car. LOL Lotsa people use metal halide for vegetative growth, then switch to high pressure sodium during flowering phase. But there are also those who use compact flourescents to germinate and during veg phase.
Like the garden knowm said, HPS produce great yields, but the downside is heat with a 1000 watt bulb. If it's your first grow, you might try CFLs to germinate and veg your plants, then switch to a HPS bulb.
All of this depends on how many plants you're going to grow. A big grow, MH or HPS works great. A small grow (1 to 2 plants) and CFLs might be a cheap and easy way to grow. So it kinda depends on your budget and how big you want to go. Hope this helps. Good luck with ur grow!