The mods made by creation kit, and the mods made using script extenders arent the same kind of mods.
CK allows modding in custom NPCs, followers and more models, as well as modifying vanilla asset models in the game easier (part of the reason why the only thing you see in modding space are texture swaps and full model swaps) as well as quest mods. These are the types of mods you see like in skyrim that can be enabled by console as well.
Script extenders enable mods that rewrite how the game functions, be it physics, adding new interactions and such.