I have several 10 and 20 gallon tanks with 1" of mixed dirt and dry cow manure (I have cattle, so I collected it myself instead of buying it) capped with 2" of either pool filter sand or Black Diamond sandblasting sand. As you might imagine, the cow manure caused gasses to bubble up for months, but the fish and invertebrates didn't seem to mind.
Plants are doing very well in it, and I wouldn't hesitate to do it again for display tanks. The only drawback is that when I remove plants to sell invariably some of the soil winds up on top. It doesn't cloud the water, so that's not an issue, so while I don't really mind, some people probably wouldn't like the way it looks.