Skyrim is a great game and yet it bores me most of the time. I don't know exactly what it is, but I do know there is just no element of reward for me. I had this same problem with oblivion, a big beautiful world but nothing that leaves me fulfilled, and because of that, no motivation to explore the world. Everything seems to be slashing and killing which is ok but when you get used to that it just feels like an empty game. Maybe it's my fault for not reading the in game books.
One thing that I'll point out is I've never been the kind to get excited over finding an ebony warhammer or something. Sure items like that give you power but I don't want power, I want a sense of achievement, that it wasnt just another dungeon with great equipment at the end. Now don't get all fired up when I say this, I'm only saying it because its true, but one of the things Morrowind did best was you were always feeling like you found something truly unique in the game; there were surprises everywhere.
So hopefully you guys have a few mods in mind. Thanks!