I may sound a bit of an idiot and cocky, but I dont really need mods. I want to play the game how it is.
Although, I havent used mods for any game yet (thats why I am against them) and i dont know if they are actually as bad (I say bad like as little) as I think.
So.... Are mods really that great?
I used to feel that way, then [insert overused arrow joke here].
But honestly, I did used to feel the EXACT same way. It felt like it was defiling the original game. Or it felt like cheating. I didn't like the idea of adding "unprofessional" or "unofficial" content into a game. Then I tried it. Truly, I couldn't go back to playing "vanilla" games, not even Morrowind. In fact, mods are one of the main reasons I TRY to always get the PC version of ANY game if it's available.
Once you start playing mods, you won't look back. In fact, you will feel as though you have been enlightened.
There's nothing wrong with playing a game with mods just as there's nothing wrong with playing games without mods. But remember, even if you do start playing with mods, you can always stop. The PC versions of games play the same as any other versions... that is unless the PC version is platform specific, but that usually means superior anyway. It's a win-win situation no matter what. The ONLY reason you should even think to get a console version of a single-player game is if you question your PC's ability to run it. That's why I got Oblivion on Xbox first. My PC still won't run it well. But it will actually run Skyrim pretty well. I'm just hungry for the mods now!

Ps. If you really want to see how much better a game is after it has been modded, play Morrowind. It's nearly 10 years old, but there is also nearly 10 years worth of content for it. The same goes for Oblivion to a lesser extent. However, there is a much larger gap between the qualities of vanilla Oblivion and modded Oblivion. I refuse to play vanilla Oblivion... where I can handle vanilla Morrowind.