here is a list of the mods I have installed for Oblivion - somewhere around 150+
I certainly hope Skyrim won't need that many
That struck me as an interesting viewpoint.
The vast majority of mods that I install aren't things that I think "fix" the game - they're just additional things that I want to play around with. Sure, I play with Fran's scaling mod (not the whole FCOM setup or anything like that), but beyond that the only things that I use to change basic features are what I consider "preferences", not "fixes". Like shorter grass models, so you can actually see things in the wilderness. Or DaRN UI - the basic UI functions fine, I just prefer a different setup.
But, like I mentioned earlier, the vast majority of mods I use are additional "stuff" - more armor & clothes, more races, more hair, more quests, more, more, more.

I never use mods.
I prefer professional work.
Like all things, yeah - there's alot of crap out there. But there's also a good amount of really nice work. (Which is why a select few "modders" over the years have ended up working in the industry).
Also, I like to play the game "The Way The Developers Intended?" - which, to me, means
with mods. (after all, they released the game with mod activation built into the launcher, and with robust modding and development tools freely downloadable).
(First play is vanilla, of course - have to see the game in it's basic state in order to decide what mods I'd like to try.

)