Oblivion mods? Martigens Monster Mod. holy shit, oblivion had bland monsters. Martigens Monster Mod fixed that right the fuck up. I also had a mod I really liked called "hillsborough estate" where you could put together a huge estate outside anvil and eventually conquer all of cyrodiil. It got pulled off the nexus for being an incredibly buggy mess with a lot of claims of stolen content leveled against its author. Cool mod though. You could make wine and all sorts of products. I usually stopped advancing in its... advancement... after buying up the blueberry farm and the bakery as I could never figure out how to do the next bit. Also CLS crafty bits. It made the game really unstable and it required OBSE, but it was a cool mod which used oblivions physics engine to do its crafting.
Off the top of my head, I cant remember anything absolutely fantastic for skyrim. Midas magic I guess. there was that big DLC quality mod, but I couldnt get it to work unfortunatly. :C
Now if you wanted mods for morrowind...