In the grand scheme of things photons are photons. That being said, any of the three lighting types can yield excellent results, provided that you are ensuring that the tank is getting an even spread of light.
Metal halide systems are half point source (the light coming directly off of the...