Landing the confusion buff on an enemy doesn’t change the actions they take on their turn with turned based mod active.
Turning off Turn Based Mode results in them behaving confused but they “sober up” immediately upon the mode being turned back on. They still have the buff but they no longer behavior confused on their turn.
Enemies do not appear to make attacks of opportunity when confused though so that’s something. Doesn’t really feel like its worth a 4th level spell slot on my sorcerer though.