I haven't really modded Oblivion much before, but after I got used to modding New Vegas and Fallout 3, I thought I might give it a shot. I use texture packs in both F3 and NV, so I tried looking for a good one for Oblivion on the Nexus, but all I can find are for small individual things, and the rest are just a bunch of nude mods. 
 
Can anyone help me out here?

People over exaggerate with the nude mods. They just get up voted a lot so people see them more. Qarl's texture mod is the definitive reskin of the game. It's environment only though.

http://planetelderscrolls.gamespy.com/View.php?view=oblivionmods.detail&id=2363

It's in OMOD format so you need the Oblivion Mod Manager to load it.

@Aronman789: I think you have to be a member of file planet though which costs money, which is weird because I totally downloaded it this morning without needing to.

Here is a gamershell link: http://www.gamershell.com/download_19977.shtml

If you follow the visual section of this guide you will get oblivion to look really nice. http://forums.steampowered.com/forums/showthread.php?t=1306005

I can suggested other mods to make the game look better too. Natural Environments is the main one you should get.

Theres a new mod coming out soonish called Andoran., its just something you can keep on your radar for a bit.