So I',m trying to find a few things:

1) Mods which complete the incomplete armor sets found in the game.
2) Mods which (realistically) add additional armor sets of each type into the game.
3) Mods which add additional weapons. Yes I know about Adul's Armory
4) Mods which add additional clothing.

Finally I'm wondering if it is possible to add clothing which takes the "armor slots" available. It's always bothered me that there are no clothing pieces available to replace armor for unarmored characters.

Regardless, I've got a little project for myself which I intend to work through slowly. I've been wanting to balance the vanilla equipment more realistically, but I realized there just isn't enough stuff to allow for more nuanced differences between equipment, and balancing unarmored is just about impossible when armored characters will ALWAYS be better in every way from an enchanting and AR standpoint. I figured I might as well ask for stuff to round out the equipment, and I figured on the off chance I share the final product that I might as well use popular stuff.

Well, here are some good mods...
http://planetelderscrolls.gamespy.com/View.php?view=Mods.Detail&id=6650

That's your armor mod that completes the sets and what not.

http://planetelderscrolls.gamespy.com/View.php?view=Mods.Detail&id=6589

And this is Wicked Weapons. Which adds awesome amounts of weapons. Although, balance wise, it can be a bit off.

as for clothing i always put Clothiers of Vvardenfell in my list of must have mods. it can be found on tes nexus under korana's morrowind mods.

And you can always check http://www.tesnexus.com/downloads/categories.php, it has loads of stuff on it. And http://planetelderscrolls.gamespy.com/static.php?page=Oblivion&game=4.

Edit... Sorry, I thought this was the Oblivion Mods page... I don't know if it is relevant know... Sorry!

In my opinion the two greatest weapon mods will always be Assassin's Armory and The Marksman Mod.