No number of mods could make it a good (not mind-numbingly boring) game in my eyes.
Just like with Oblivion, the mods can make it look better, improve the UI, and correct some of the scaling and loot imbalances, but it's still Oblivion at it's heart.
I'm finding Dead Space, which is...