So first it's a new card that makes you search your deck and so that can trigger Astounding Revelation and Surprising Find (and Occult Evidence in a Mandy Thompson deck).
It's also a tutor among 6 cards at the cost of 1-2 clues. And technically a "pay 1 resource and place 3 clues on your location to draw 6 cards" event.

And finally I think it will be interesting in a Barricade deck (meaning a deck in which you investigate without moving from the location you played the Barricade in): you put on your location (where you an always investigate) clues that you got from other locations (which required to use cards such as In the Know or Seeking Answers) to draw cards to get the other "distant clues". With the side bonus of Astounding Revelation recharging In the Know.

This card is absolutely insane. For 1 action and 1 resource cost, you could search and selectively draw up to 6 cards. Dropping clues might sound like a heavy burden, but with 2 Research Notes in play, dropped clues potentially double back, so you actually benefits from dropping clues. However, I have only tried this combo on 4 player game and I assume that it doesn't work well on solos or 2 player games.

Captivating Discovery is one of the fascinating card which is spoiled in scarlet keys. This provides the 6-cards searching effect, which helps to trigger the Astounding Revelation. In addition, this gives the 2/4/6-card drawing effect among 6-cards, which is powerful search/drawing ability. Someone might think that dropping the clues is expansive cost. Unlike other clue dropping cards such as Forewarned, however, the player can easily control the timming of the playing Captivating Discovery because the drawing effect is independent to the location. Thus, you could select the location to drop the clues. You may drop the clues at the location with low should value. You may drop the (unnecessary) clues at the location with non-victory location. It means that the cost of "dropping the clues" for Captivating Discovery is commonly lower than that for any other cards.

I think this isnt too good (especially for regular use).

It costs 1, an action to play the card, the card itself and require you to drop a clue (approximately an action). For all that effort you get to look at 6 cards and draw 2. So 3 action and 1 resource to get 2 cards.

Even at it's best, for 4-5 actions worth of stuff and 1 resource you can draw 6. You're probably better off just drawing cards unless your deck need specific cards or can HEAVILY leverage the dropping clues.

There is a tradition with player cards, that they are kind of made for the investigator depicted on them. There are exceptions, as for instance Silas can't take upgraded Overpower, and even more so Sister Mary does not Keep Faith. But in general, it is rather the question, whether the character is even allowed to take the card, not if it would be really good for them.

There is another tradition, that sometimes player cards give hints for upcoming releases. Inspiring Presence from Carcosa foreshadows Leo Anderson in TFA. "Before the Black Throne" teased the Bonded mechanism with Hallowed Mirror and Occult Lexicon, which was a big thing in TDE. Tony from TDE got a Deep One enemy as his weakness, sadly not one with the signature ability of Deep Ones to do something bad on engagement. Lex Luthor from TFoHV is supposed to be somewhat linked to the Mafia themed next campaign...

Now keeping that in mind, it seems obvious, that the person on this card is not Rex Murphy, it is Rex Murphy! I can arguably see the card as tech for a true solo deck of the Dunwich investigator to drop a clue on a 1 location to proxy his ability, but there are better cards for that, and he is not great in solo anyway. For his parallel ability however, this card is made for!

It seems odd for me, that a card from an official product is foreshadowing a print and play release. Sure, we had an April Fools Day joke about a Blob Investigator hinting at p&p Suzi, but that was just on the homepage, not from inside a box. Of course, I can be terribly wrong, but I have high hopes now, that we might get a proper release of these parallel investigators. I know, it won't happen with Gamezenter anymore, but maybe they reconsidered doing it themselves at FFG? Fingers crossed!