Morrowind is imo the best from a gameplay mechanics perspective. The utility magic alone was such a huge loss for future games.

I could cast levitation, walk up to the moon prison, magically open the lock, use chameleon to sneak inside, steal stuff from 30 feet away with telekinesis, and if the guards find me, jump down with slowfall and then escape underwater with waterbreathing.