This is probably not a great solution, but I have always modded my elder scrolls games to within an inch of their lives, and Skyrim was no different. I love some of the quests that people have made, ones that expand the main quest choices, and ones that retexture.
That said, Skyrim is definitely not a perfect game, the story is surprisingly thin on the ground, and for such an open world game you really don't have that many options for how to play through the major quest lines, so if sandbox style rpgs aren't your thing then I wouldn't bother.