^ The only good LED's direct the light downward, which is great if you want to light a street from a tall pole. Not so much if you want to spread light over your whole yard. I have not yet seen a truly good LED replacement for the classic NEMA bucket light.
I don't really like metal halide security lights unless there is a compelling need for white light. The lamps don't last as long as the other options and it seems the newer pulse start ballasts go though ignitors pretty quickly unless you are VERY diligent about changing the lamp. Up to about 100w there are ceramic metal halide lamps that have very good CRI and a nice boost in efficiency compared to the more common quartz metal halide, they are quite a bit more expensive though.
HPS is pretty good, efficiency is about the same as most of the LED stuff out there. Ballast failures are few and far between. Lamps will usually last 6-8 years running dusk-dawn.
I still like the old mercury vapor lights. They aren't quite as efficient as the other options but they just last forever. I know of many MV security lights that probably haven't been touched in the last two decades, they just keep working. The downside is the fixtures are not made anymore and the lamp quality is not as good as it used to be. Back in the 80's you could get lamps that would do 20+ years without dimming out. Today the lamps will last about as long as an HPS before they start to noticeably dim.