TES Nexus that MILF mentioned is the be-all-end-all.

Also look for the Oblivion Wiki and find their suggested mods. I probably play with a couple of dozen mods that I couldn't live without any more.

One I highly suggest is the Armory Lab. This one alone made the game infinitely more fun for both me and my wife.