The 48 current Creation Club items that you'll get access to as part of Skyrim AE range from special weapons, to new enemy types, quest expansions, and gameplay changes.
If you'd forgotten about Bethesda's Creation Club, it's a marketplace of paid DLCs developed either internally by Bethesda or by approved external creators.