I'm choosing spells for my now 6th level Warlock, and I'm reluctant to get Hypnotic Pattern for her as she already has Fear, and it looks like they both serve a similar purpose (Area of Effect that imposes a condition) and have a similar weakness (Wisdom save to ignore/recover from the effects):
Fear:
While frightened by this spell, a creature must take the Dash action and move away from you by the safest available route on each of its turns, unless there is nowhere to move. If the creature ends its turn in a location where it doesn't have line of sight to you, the creature can make a Wisdom saving throw. On a successful save, the spell ends for that creature.
On a failed save, the creature becomes charmed for the duration. While charmed by this spell, the creature is incapacitated and has a speed of 0.
The spell ends for an affected creature if it takes any damage or if someone else uses an action to shake the creature out of its stupor.
I don't see much point in having both, especially as warlocks have so few spell slots; I'm rarely going to need to cast both as far as I can see?
To my knowledge, we aren't facing any enemies that would be immune to charm instead of being immune to being frightened, nor a reason to prefer cones vs cubes etc.
So I'm now, instead of trying to pick between similar spells, I'm looking for spells that can serve as utility knives - able to impose multiple conditions. Either by the casters choice at time of casting, or automatically imposed together. Spells like Eyebite come to mind, but I can't find others on D&D Beyond due to my searches looking for either condition not both.
What spells fit that criteria (I'm interested in ones available to all classes in case my GM is feeling generous in what I can learn)?