200 mods is baby numbers lol, most decent Wabbajack lists now days are over 1200 mods. I think my personal list is like 1800
Modders have made Skyrim SO much better than people who haven't played recently realize. There's mods to completely overhaul combat and make it an extremely fluid Soulslike, while also adding things like hanggliders from Zelda + 8k textures and high effort animations etc to make it look better than most new games
Bethesda is going to have a hard time actually making TES 6 stand up to modded Skyrim by the time it comes out in 2030+
You don't need to follow the changes since Skyrim is a static game. The first step of modding Skyrim is you turn off steam updates for it entirely, then all your mods will work forever
The wabbajack authors also do put out updates pretty regularly to update mods to newer versions or replace them entirely. You just re-run the wabbajack installer and it will overwrite the out dated mods with the new ones