I have not ran LEC/CMH and dont plan to. Though it might have a better spectrum than HPS, I have not seen the evidence of the results.
I also dont really care for grams per wattage, as that mostly depends on strain. Too many variables involved in that number (tent, tent temp, reflector (or light density), water temp, PH, EC, feeding cycle, flushing, etc).
I think LED has every product beat on efficiency and spectrum, as it can be tailored rather simply, whereas metal halides and sodium lamps are at the beck and call of the resonance wavelengths.
I personally use only LED's and HPS. I now converted my veg into using only LED from T5's and love the response.
Here's a pic of DQ under the lights a few years back that I just found on my comp. Not sure what the yield was per watt, but it was definitely quite successful.
View attachment 4027822
One thing I dislike about Metal Halides is that it makes the plants stringy and tall. I like cramming the nodes as close together as possible to get a condensed cola. HPS works great for that, and LED makes up for the spectrum deficiencies, at least that's how I look at it.
Oh and about the densest heaviest yields being in a greenhouse....have you ever seen the CO2 enhanced bud? I think that might have nature beat. Too much hassle for me though lol.