if you loved it on console you'll love it even more on PC imo, if you're more of a controller gamer there's options for that, and some of the mods out there are just great, they fix bugs, add new content, and one of the more prominent mods adds a whole new map/world/land to the game, a full fledged DLC all for free. Out of all the mods I have though I think Skyrim Redone is the mod that makes the most noticable changes to the game, AI, combat, perks, weapons are all changed pretty drastically.
You have a ton of flexibility of what kind game you want Skyrim to be, there are mods for visual changes, animation changes, difficulty changes, perk changes, etc.
I've uploaded some screenshots of what the game could look like, I've used high quality textures for almost every aspect of the game including buildings, rocks, trees, and grass, and an ENB (changes bloom and color saturation to give a different feel to the game) of my choosing. And this only showcases the visuals changes you can make.
*will link to screenshots once this uploading is finished, my connection is pretty slow