I'm sorry that I didn't get in on the earlier conversation about the "best" substrate, but I have to add that I have been VERY happy with using a false bottom system and coconut husk chips mixed with activated charcoal (horticultural type) as a substrate. The false bottom allows easy setup of a circulating pump for a waterfall or other water feature which increases humidity more than a standing pool, allows for better oxygenation of the water for nitrate breakdown, and discourages stagnation which leads to a foul smell (my terrarium smells very fresh and clean all the time).
In addition, this substrate is not heavy at all (unlike gravel), is airy enough to place bromeliads in (they thrive in this stuff), and an ideal substrate for orchids. In addition, I've found that java moss and club mosses grow very well on this substrate, but have only had limited success with pillow moss. In addition, it is really inexpensive to buy (I bought enough to build five 50 gallon terrariums, along with a coco fiber mat for about $25 at www.rolanka.com. You just have to be sure to soak it and drain it well (3-5 times at least) before using it.
Okay, I'll get off of my soapbox now. Thanks for listening.
-----
Homer W. Faucett III, esq.
Purveyor of Trivialities and Fine Nonsense