The texnexus site is a very good resource site for Oblivion mods, and I highly recommend using that site as a base. However the site is very big and it's hard to find the good stuff unless you got some pointers in what to search for. What I recommend is that you join some communities that help you find your way in the texnexus jungle.
Game Vixxen Zone is a site is primary a skin resource site, but it got a very good Oblivion section. Some modders share their mods there, and members of the community post their findings there if they come across a mod that they really like. I assume you are an adult as you are posting on the site here, hehe. You need to register at GVZ to be able to get full access.
http://www.gamevixenzone.com/gvz/ There is another very good site that focus on the exnem body mesh and all kind of mods that got the exnem body mod in it, ( shops, cities movement and pose mods body alternations etc. etc. etc. ) On this site the developers them selves post their mods and they keep you updated on projects that they are currently working on. You find excellent lists of mods that let you make your oblivion chars stunning. Most modders there focus on female characters but if you want adult male char mods I recommend you check out Alienslof's site and mods.
http://teseyecandy.com/forum/index.php
http://www.slofshive.co.uk/index.php You find some mods that are direct links on these sites, but most of the mods you will find linked to texnexus.