I've downloaded mods like Moriarcis, AliveWaters and the full Unique Landscapes pack, and have checked them in the data files, but the content doesn't appear ingame. Why?

You're going to want to start by reading through http://www.gamesas.com/index.php?/topic/449239-oblivion-mods-faq/.

gothemasticator