Mind Wipe was quite bad card. Most enemy with annoying effect has Victory X, and Mind Wipe remove Victory. I believe most of you don't want to forget Victory to avoid annoying effect. Thus, in many cases, Mind Wipe is adopted to counter annoying weakness enemies such as Your Worst Nightmare, The Thing That Follows, or (friend's) Tommy Malloy. Sometimes, Mind Wipe is utilized as single target Taunt to make auto-engage against aloof enemy.
As the time is gone, some of enemy have annoying effect without Victory point. In this reason, Mind Wipe become considerable card in some campaign. Nevertheless, the play timing of Mind Wipe is quite bad, and we need to consider to counter enemy. You can only play Wind Wipe to the enemy with you at the start of phase. You cannot play for hunter enemy moved to you during enemy phase. You cannot play for just spawned enemy during mythos phase. You cannot play Mind Wipe after you move during your turn.
The below contains spoiler about many campaign.
Forgotten Age: As the other review said, you can remove annoying Vengeance X. Additionally, there are some more target such as Brood of Yig, Brotherhood Cultist or lots of aloof enemies.
Innsmouth Conspiracy: Commonly, you cannot ignore engage effects of enemies. However, Deep One Nursemaid is good target (during mythos phase or investigator phase).
Edge of the Earth: EotE has many enemies for Mind Wipe. Skittering Nonsense, Primordial Evil not to get Tekeli-li card. Lost Researcher, Frenzied Explorer to remove doom with defeating. Horrifiying Shape, Giant Albino Penguin for auto-engagement. Guardian Elder Thing to avoid milling your deck. Constricting Elder Thing to instant kill (in my opinion and it may wrong ruling). In fact, I determine writing this review because of Edge of the Earth campaign. There are many targets for Mind Wipe, and I think you have a chance to playing Mind Wipe for all scenarios.