There are many different artifacts (unique items) in morrowind, that are the single ones in the game. These arifacts have many different magic effects that are way better than just normal magic weapons. Most of them have their own look, so they're not even near of the normal weapons that you see in shops etc.
If you want to get a specific equipment it doesnt necessarily have to be a mod.
Just find out where these artifacts are, most of them are associated with a quest. So joining in guilds and different factions is a good way to start looking for them.
Some artifacts can be obtained trough a daedric prince ( the "evil" gods). When you find a daedric statue (mostly in daedric ruins) just check if you can talk with the statue, it may give you a guest.
There is anyway many artifacts that can be just found.
If you want to know the locations of some of these artifacts go check uesp
(The elderscrolls wiki) - there you can find every artifact in the game.
Or you can just Pm me, I know many of them as well as some other good items.
