Quickleaf
Legend
What if you flipped it? Rather than working best on creatures at low hit points, the spell only worked on creatures at full hit points? Creatures that are currently in pain will not succumb to the subtle drowsiness of the magic. Sort of like how creatures in combat save at advantage against charm person.
EDIT: I see you're thinking along the lines of charm person already.
Yep, great minds

That's an interesting idea! I think it works fine for most cases of PCs casting against monsters/NPCs (since the main vector for monsters suffering damage is usually the PCs). But it doesn't work so well for monsters/NPCs casting sleep against PCs, since PCs can have scrapes and scratches and bruises from other adventuring scenarios.
I'll think about it.
Looking over my first try, I can already see that the 3 saves thing I borrowed works for single-target spell like flesh to stone, but for a multi-target spell like sleep is going to be a pain-in-the butt amount of dice rolling. And more saving throws multiplied by a group of monsters mean that just by sheer probability putting a group of weak monsters to sleep has lower odds. Probably not ideal.