With how graphical mods and countless other aesthetic mods made Oblivion an entirely new game all together. One can only imagine now that after mention that they're releasing the mod kit on the PC version, this game is going to be better than real life once the modders get their hands on it. Although amazingly awesome, I'm not into the type of mods that allowed combat on horseback, wings, flight, riding dragons, Midas spell packs etc. Which is why I'm sticking to aesthetic modifications.
Here's some reminder of a few minor tweaks that were done to Oblivion. Put them in highest quality and enjoy.
http://www.youtube.com/watch?v=xc3zEXYm6FY
http://www.youtube.com/watch?v=XmF9ewdualU
http://www.youtube.com/watch?v=5F4cmO_TjaQ