In order of performance. Cost Represented by ($-$$$)
1/2 Pretty much even between a dirt cap ($) and ADA Aquasoil ($$$) (Tom Barr has done studies to confirm this.
3. Some other kind of aqausoil (Fluval Satrum, Brightwell $$$)
4. Activ-Flora ($$) - Hard to find but good thread documenting its success
5. Eco-Complete/Florite ($$)
6. Sand (No additives, if you add root tabs I could see this moving above the eco, several members here have success with this $)
7. Plain Gravel ($)
Substrate choice is very important. If you are on the lower end of light etc., it becomes less of an importance but still needs careful consideration.