Zelda... you read my mind.
I bought Oblivion(for the 3rd time!) last weekend during the Steam deal. I've been playing it like a crazy person.
This is a good site to start for mods http://www.uesp.net/wiki/Oblivion:Must_Have_Mods
Let me know if you find something worth getting that's NOT on this site.