I know there is an awesome mod that redid all the textures throughout the game and made Morrowind look 1000 times better. I forget the name of it though.
Where did you hear about this super-huge-mod you speak of? Because it doesn't exist.
There are some large mods that cover all the architecture and landscape, but no one person has ever done all the textures in the game.
You need to use the work of at
least 10 modders to update all the textures for the weapons/armor/creatures/furniture/misc objects/ingredients/etc, etc, etc.
The links above will provide you all the ways of finding the mods.