here is a mod for improving Oblivion graphics:
Gamespot- Oblivion Make it Pretty

it a worth to look at.
other mods I dunno, i'm searching for good mods too.