In my experience Mother in Law's Tongue needs high light levels - if left out of a sunny spot for any length of time they grow very tall and then flop over.
I would also question growing succulents successfully in shade - the reason they have developed those fleshy leaves is because they live in dry sunny spots. They will survive in lower light levels for a while, e.g. if you have to bring them in to overwinter them, but they will become pale and etiolated if in the shade for any length of time.
Cissus antartica http://www.plants-in-buildings.com/documents/cissus-rhoicissus.pdf doesn't mind fairly low light levels, The House of Plants website mentioned earlier also has some good suggestions. And of course the aspidistra is well known for it's ability to tolerate shade.
There are very few flowering plants that will live in the shade.
I'd still go for a terrarium planted with ferns and mosses.