It let you create your own story of doing bonkers shit to borderline break the game, it let you actually be creative. There was vaults full of high level armour and gold, to rob it, I made a teleport marker in my house, I then went to where the vault was, cast an unlock spell on the vault door and then turned around and stole a vase off the shelf in the corridor outside the vault. The guard inside the vault saw me through the vault door window. Because id unlocked the vault door he runs out of the vault to yell at me. I paid the fine for the vase. But now the vault was empty and the door open. So I turn invisible and walk inside, turn around, close the door, and cast a lock spell. Im now alone in a locked vault. I then hid around the corner, out of view from the guard who was now in the corridor locked out of the vault. I then used telekinesis to pick up every item in the vault making me way way over encumbered, but all out of sight of the guards. I then teleported home with the entire vault in my pocket.
Later I enchanted a ring that cast an insane jump and slow fall spell, and enchanted a sword that cast a 50ft fireball whenever you hit anything with it. Those combined allowed me to leap 100 ft in the air, slow falling down, whack something with a sword causing a huge explosion killing everything around whilst I then leapt back into the sky like a giant kangaroo of doom.
Later games, particularly Skyrim dumbed down a lot of that stuff, and it was much more boring and less creative as a result.