Ultimately, plants only need so much light intensity so closer isn't always better... without a PAR meter I don't know how you'd tell though. Grow lights usual have guidelines saying what PAR to expect from various distances from the light so you can make best use of it.
If you are growing indoors you probably don't need or want the excess heat created by halide or sodium lamps as I assume your home is around 70F. If you are growing outdoors or in a cool place that benefits from extra heat you have to have to consider if it would make more sense to use gas or fuel heat rather than electric and LEDs or fluorescent lights to produce light. This only matters at a certain scale.
At small scale, inside your house, I suggest using LED or fluorescent because you're less likely to burn your plants, or burn your house down
EDIT - looks like metal-halide aren't as hot as I thought and are reasonably efficient... 300 watts might be okay if you have a cage around it to reduce fire hazard. I think the high pressure sodium ones can be like 1,000watts. I'm no expert in any of this, I just tried getting lights for the first time this year. I've been looking at it on and off since before LEDs were commonplace. Those Cree COB lights look pretty cool, didn't even know about them