It's all personal preference.
I use all kinds of substrates - even Turface-like products. They all work well.
But I prefer ADA Aquasoil because it already contains nutrients (less I have to do in low-tech tanks re: ferts), looks attractive and helps buffer my water. I use it in smaller tanks because it's decently affordable to fill a 10gal with it.
I like Turface and pool filter sand because they're cheap and can be used for larger tanks without breaking the bank. Turface and Safe T Sorb have high CECs so they're great for holding onto ferts for root feeders.