Do I want an ai overhaul? Sure, but I would expect something like that to happen during the programming of the next game, not in a patch for Skyrim.
I'm not expecting anything radical, and I'm not going to cite what mods have done. imo what would be a huge boon is just conditional awareness of the player and allies/enemies.
I am/am not the target of the player
I have/have not allies to help me
I am/am not in possession of ranged attacks
I am/am not outnumbered
I have/have not a certain defense/offense towards an enemy.
but yeah, I await what the next iteration of the series have to offer, in AI and how it handles "difficulty" imo how its handled now, as well as the divorce between it and other game mechanics or those that no longer exists (failing spells/speech checks etc etc) I vouch the difficulty bar just get omitted, and let this lol Radiant System handle the health sponges