Even if it doesn't, you've got to manually configure the mods in-game. There are still some steps you need to manually perform, especially if the guide you've picked recommends an ENB wrapper. When you wake up, you have hundreds of Skyrim mods ready to go.
If you're going to do this, you should start from the beginning-see what the community has made since the last time you looked. But, you realise, you're a different person now. Maybe now's the time to finally play it, you think. You're between games, and, browsing through your Steam list, you remember all the hours you spent modding Skyrim all that time ago. This is it! You're playing modded Skyrim!
There's a kind of separate game that exists above Skyrim that doesn't really involve interacting with Skyrim at all.