Full disclosure but I've never played someone else's modpack. I've downloaded multiple from Wabbajack but I'm so picky about everything in game that I immediately start ripping chunks out of it. But I do have some recs from the community.

Not actually Wabbajack but Gate to Sovengarde is supposed to be easy to install and vanilla+ type. Pretty well tested and pretty stable, includes a lot of the dynamic world changing mods like Seasons and reclaiming locations after you clear out bandits and the like.

Path of the Dovahkiin overhauls the game to be a more ARPG experience with a focus on character builds, dungeon crawling and looting.

Living Skyrim and Wildlander are supposed to be increased difficulty immersive survival overhauls that probably aren't to everyone's taste.

People who enjoy modding Skyrim into Dark Souls talk a lot about Nolvus, but learning that the modpack includes "Immersive Wenches" has made me slightly question its 'ultimate lore friendly and immersive experience' lol