A great card, fairly costed in both resources and XP. This card gives a little glimpse of what the 0xp Oops! should have been, it was just missing that clause about friendly investigators.
The expanded failure range and "any enemy" clause in the text is what makes the card worth 2xp. No longer requiring 2+ foes at a single spot is a terrific enhancement, worth the 1xp. The expanded failure range means that you can attack a 3- foe and "automatically succeed", this is definitely worth the other point of XP since there is indeed a lot of 3 fight foes, bosses even.
The only disadvantage to Oops! compared to "Look what I found!" is the net benefit. "Look what I found!" turns an attempt to find just a single clue into twice as many clues obtained, Oops! nets you the 1-to-1 damage ratio of whatever you attacked with, so Oops!'s benefit becomes greater, the greater the base attack is. I'dd say to go and try it out with an Ornate Bow as Wendy Adams, or an Old Hunting Rifle as William Yorick, you will probably be pleased.