The Anniversary Upgrade got a lot of flak upon release because a lot of people disagree with creation club content on principal. Additionally, it broke SKSE (Skyrim Script Extender) meaning your mods wouldn't work anymore. I wouldn't necessarily say I agree with the whole Creation Club idea either, but I really enjoyed the added content in this expansion. The added armors look amazing and the addition of Chrysamere from the older titles is really cool. If you examine the expansion by itself, it really is quite solid in my opinion. Additionally, SKSE has been patched for anniversary addition. I played this expansion for ~20 hours and all of my mods, including gameplay changing ones that relied heavily on SKSE, functioned perfectly fine. Just make sure you get the anniversary version of SKSE and you'll be fine.
