Well, it depends on what kind of mods you want... You don't have to be totally familiar with the CS to install mods. I installed alot, and I barely know how to use CS.
Many people have different tastes and there are many mods. Quest mods, NPC's adding mods, landscaping-altering mods, face mods, 'vampiric' mods, werewolf mods, etc. There are just so many.
I suggest you search the Mod Database/Mods sections in the site of
Morrowind Summit or
TheLys.
*points at Screenshots Thread* Read one of my posts there. I listed a bunch of sites with some mods, in case you're interested.
Oh, and one more thing:
Many mods use the expansion packs. Especially quest and companion mods or mods that add a new place/city/town/village like Khaan's mod. :ashamed: So, if you do not have the expansion packs, your options may be a bit limited.