Some modifications tweak the graphics, add new quests or weapons, or improve the third-person perspective to make Skyrim a more enjoyable experience.
Perhaps one of the best things about Elder Scrolls 5: Skyrim, and the reason it's still going strong to this day, is the modding community.