Sleep is a great spell if utilized thoughtfully.
Until you get Cull the Weak, at which point Sleep becomes a silly choice, at least in this type of game. I could see it still being useful in some sort of tabletop game if you didn't want to kill an enemy. But in BG3 we don't take prisoners.