Did you find you needed to supplement w/ CO2 at all? That's really the thing that is holding me back on this idea.
No, for this tank, I was inspired by the writings of Diana Walstad in her book "Ecology of the Planted Aquarium". In it, she tackles the science and philosophy of CO2 through "biology" instead of "technology". But that requires a very active approach to your substrate design, tank loading, and water change regime.
A moderately rich yard soil with a moderate amount of organic matter will supply CO2 sufficient for most aquatic plants (at least, that I have grown). However, the potency will run out over time and what you'll be left with is a tank substrate that is biologically "slower" and proportional in nutrients to the inputs into the tank (i.e. dead plant matter, fish waste, food waste, and water changes).
But I find that I rebuild my aquascapes and replenish the soil about every 12 months anyway, so this works for me.
Due to my moderate success with soils and MH lighting, this is where I diverge from the LowTech philosophies and understandings. The substrate is the "life-heart" of your planted aquarium. Too many people underestimate the value of a proper substrate, and hence it skews their perception of lighting, CO2, and algae.
In short, if you pair your MH light with a proper substrate and have minimal fish and inverts, you should do ok. The hard part, without measuring the photosynthetic active radiation (PAR) of the lights, is to know when to let algae run through it's "cycle", or if you are truly overdriving the biological speed of your substrate; i.e. it's ability to cycle nutrients and create CO2.
This is where the PAR meter, knowledge about your substrate, and actual tank experience come into play.
Unfortunately, the timeline of how your tank responds to environmental changes takes course over many weeks and months, not days - which is the observation span of most hobbyists. This is especially true in a non-CO2 tank where the biological dynamics are much slower than a tank artificially injected with CO2.
In the past, I have been asked whether I think ADA Aquasoil or Eco-Complete are good substrates. I've never used them, but even though they are soil-based, I question whether they are proper in terms of a soil's ability to host the bacterias that are necessary to cycle the nutrients that are inherent to the substrate in question. I also question whether these substrates have a full range of nutrients for the plants.
When I used my back yard soil, I sent it to a testing lab where they provided a break down of all the major nutrients and minerals, as well as checking for harmful chemicals and substances.
Unfortunately, there is no simple answer to your question because there are too many interactions that take place in a planted aquarium. All I can say, is that with some care, I have used MH over a non-CO2 tank with success.
Cheers!