Like the phoenix I rise from the ashes of unproductivity and laziness, ready for the coming flood of vociferous creativity! And also gratuitous lexical chest-puffery. Yes, after a long silence I like to break out the $5 words.
Mods are great for enhancing gameplay in Skyrim, of course. For anyone playing Skyrim I would seriously recommend spending some time poking around the Steam Workshop as there are hundreds of awesome mods by incredibly creative people. And if you're an aspiring game designer, its also a great way to get your talent out there whether it be in design or level building. The possibilities are multitudinous, up to and including making the game world completely batshit nuts.
It has come to my attention that some of my lovely internet friends have not yet played Skyrim and are planning to start soon. To this I say - Hurray! Welcome! Prepare to have the next few weeks of your life dominated with thoughts of ingots and cheese. And sweetrolls. And "Will someone for the love of god kill that damn Talos evangelist in Whiterun?!" Also possibly "If you don't shut the hell up about the Cloud District, Nazeem, I will cut off your head, stuff some basil down your neckhole and have my storm thrall barbecue your ass for dinner." Oh right, I already did that.