Lets look at the mod situation right now. Start with obse 64 since its basically required, gives you all the good stuff like new animations and mechanics. The alinor reshade makes everything look way better with improved lighting, and its pretty stable. Quality of life stuff is already showing up on nexus, like getting rid of those annoying intro logos and making the menus faster to click through

For gameplay changes theres already some decent combat tweaks and inventory management fixes out there. A tip worth noting, grab the encumbrance modifier if youre tired of walking slow when carrying stuff. The modding scene is growing pretty fast with about 20 solid options available, and more showing up almost daily on nexus. Maybe interesting - someone even made the adoring fan less annoying if thats been bugging you

Everything works smoothly even without official support, just make sure to back up saves before trying anything new. The community is doing their thing just like always, making improvements where needed and fixing those little annoyances that drive everyone crazy