Yeah, I should've been a little more specific. I have Skyrim Special Edition, so any overhauls, i want to keep it pretty much vanilla just want to make sure it runs well and looks great.
IMO the vanilla game with just the patch and SkyUI is a perfectly good experience, even to this day.
There are maybe a couple base mods I would recommend, but you'll only notice an improvement once you've already experienced the vanilla game for a while. These are:
Static Mesh Improvement Mod - SMIM - Static Mesh Improvement. Improves the Meshes and basic textures of 3D models and clutter items in the world. Doesn't change anything from the game experience so it's a nice to have.
Realistic Water Two SE - Realistic Water Two. Improves the general look of water and makes water bodies better looking overall. There are a few of these water mods, but this one is fine.
That's it. The reality is, most mods are aimed at people who have already exhausted what Skyrim has to offer the first time around. Even stuff like re-textures, lightning or weather mods, etc. could probably stand out from the rest of the game if you are not modding extensively already. So my recommendation would be for you to just jump in. Then, if after a few hours you feel you need something to punch up your playthrough or found something annoying you wish you could change, then you can come back and check if there is a mod for you.
If you need help or anything, tag me up here and I'll see what I can do. I'm not on meta much, but I'll try to help.