It was just the graphics and combat that annoyed you? but there's so many other annoying things in Oblivion! :laugh: ... if there were any other annoyances feel free to list them.
First off the http://www.gamesas.com/index.php?showtopic=1010109 has lists for graphics mods and combat mods.
You'll also probably want something like Hear No Evil, Reneer's Guard Overhaul, etc. for the "all knowing guards!" issue.
Can't think of much else off the top of my head... the unofficial patch obviously...
EDIT:
1: check http://www.gamesas.com/index.php?/topic/820948-scaling-overhaul-comparison/
2: Obse, Wrye bash, OBMM, and you know... just search the word "extender" on tesnexus.