It is a little rough around the edges, and ripe for modding, which is why it has one of the most active modding communities of any game currently available.
The problem is, there are separate mods for each platform, and there are literally thousands to choose from. This is largely due to the vibrant modding community that surrounds the game, making substantial upgrades to bring it more in-line with more modern experiences. The Realistic Needs and Diseases mod solves that issue. This mod is perfect for those of who you have already smithed the top armour sets about hours ago.
Each item comes with its own lore and there are a bunch of new sets and individual items you can add to the game. Not a magic fan? Then check out the Immersive armour and weapons mod. Each spell comes with its own little bit of lore and adds a bit of pizazz to Skyrims otherwise fairly vanilla spellcasting. The Apocalypse mod ads spells to Skyrim, from everyday basics to terrifying destruction-based hexes. A few introduce entirely new locations and quests. But what mods to choose? Some fix problems, others introduce new magic and weapons or make life just that little bit more convenient for the adventurer. From there you can download to your console provided you have a Bethesda.