My experience still under Patch 6 (so in 2024), is that BG3 allows the saving throw at the START of the turn, in addition to the save already done when you cast it, so enemies need to fail twice in a row to even be affected one single turn ...
And that is two saves in a row for a spell (Confusion) that often will do nothing on many enemies.
I was bummed out when I realized this and unprepared it. I was lucky and two Gith had failed their save... but it had zero effect as they saved again at the start of their turn.
I am hoping this will be fixed as if it was a bug, even though BG3 is reaching the end of its patching cycle. Or maybe mods will be able to fix this?