I'm not disagreeing with you, just adding data. Different plants have varying degrees of success in different grow methods, such as suspended mist, hanging root flood (mats, generally), root flood in inert media (coconut balls, clay balls, etc), and plain dirt or mulched sand (as you said).
I was highly interested in visiting the Disney Orlando aquaponics gardens, and disappointed when i heard they were shut down. I bet they charge a fortune for their accumulated plant grow database.
I am also thinking that if the majority of plants need the mulched sand, and so do the "rain water filter bed and rabbit and children play yards", then standardising on that vs having 3 or 4 different grow methods might be easier? Just thinking that most of the hardware in hydroponics grow floats is plastic, including the water beds, and it's in sunlight UV degrading, it's just easier to contain sand, and the water won't slosh out of the sand.
I am not against hydroponics/aquaponics, just saying that i'll have some dirt on my place in addition to any other grow methods.
Just to append the bad side of the coin, what you may be up against.... One town i lived in, the humans on the town water supply all got dysentery two days after the first heavy spring rains, every year, for decades, and no one knew why, until CDC pointed out all the cow manure washed off the pastures into the intake water, which was passing all the tests supposedly used. There was a forest i occasionally drove by somewhere else, seems someone made a huge political contribution to get a bill passed so they could spray hog sewage on the forest several times a week, and the stench in local residential areas was worse than the cattle feedlots in Kansas. People tend to develop emotional gut reactions, irrational even, and will oppose having their food supply dosed with waste, however cleaned, purified, composted, irradiated, treated, etc.. Remember how many tons of salad produce were recalled one year when some farm laborers shat in the fields, and people in several states got sick?