On what platform are you playing Oblivion because if it ain't the PC you can't get any mods into the game...
I think the OP knows that. If you have a semi-decent computer, you may be able to experience the game on the PC. Many people, including myself, have many, many mods to greatly change the experience of the game. If you wish, post your specs and we can determine if your PC is up to it.