Anyway, bitching aside (sorry, got carried away there) I just wondered for curiosities sake if the plethora of mods now available actually make it a decent game yet?
No and there never will be. The Skyrim modding community is too far up its own ass to even recognize what problems the game has. They are obsessed with easy and simultaneously needlessly complicated micro-tweaks that in the grand scheme of things still amount to nothing.
For example, combat. Its bad but not because the bandits are not rolling around enough or because mages are not spamming enough fireballs. Its bad because its all just one template copy pasted a couple thousand times. They all only ever suicidally charge you spamming whatever attack was assigned as their primary with 0 regard for their survival or stats. Its always the same exact encounter with just switched around participants. The end result is a game where the optimal counter to all the zerg rushes is to just never allow the rush to start with stealth archery.
The fix to this would be to make enemies with different behavioral patterns and stats. Like glass-canon mages, or low dps but high health animals and so on. Or a buff to everything else to make them viable to deal with the clone armies.
The fix applied by the community is to cripple stealth archers while providing minimal buffs to everything else.