
Tutors (i.e. cards that search your deck for a card and draws it) are only as strong as the selection of cards they can draw for you, which for the case for Dr. Horowitz, means she's as good as the relic cards in your deck. This observation, combined with the fact that the good doctor is a lvl 0 card, makes her a bit fiddly at the start of a campaign, where she'd feasibly be included unless you're willing to pay one exp for her later on.
There are, as of Dream-Eaters, six lvl 0 Relic cards, and only one relic, Tooth of Eztli. Of these relics, four occupy the accessory slot, which means extra relics in your deck will not be playable unless the first relic you play leaves your play area for some reason or other. This, coupled with the fact that the available relics don't synergies all that well, leaves Dr. Elli Horowitz rather lacklustre at best...
...Right until the likes of Key of Ys, Timeworn Brand, and Pnakotic Manuscripts start populating your deck, then you'll be praying she ends up in your starting hand. The more expensive the relic's resource cost, xp cost, and number of slots they occupy, the more value Elli will provide by completely ignoring the resource and slot costs, and speeding up the process of getting out your big hitter cards.
This doesn't make her any less fiddly though; once you're committing to including her in your deck, your selection of upgrades shrinks a fair bit. You'll likely be investing into at least one Relic Hunter and one Charisma, the former as insurance in case you draw two or more of your relics before Elli, and the latter because you'll likely want to include other allies in your deck, especially early on in a campaign where her usefulness is lacking. And of course a significant portion of your earned exp will be spent on relics, of which thankfully you get some leeway on where you want to take your deck, either in a combat-focused direction, or a more clue gathering angle, or a whole range of unorthodox functionality.
In conclusion, Dr. Elli Horowitz is the type of card you build an entire deck (and upgrade path) around; you certainly don't use her for her early-campaign power and then replace her once you get some exp. No half-measures; either she is the focus of your deck, or she isn't in your deck at all.
As for which investigators she'll likely be collaborating with often; naturally Ursula Downs has the relic synergy to make full use of Dr. Horowitz, and Mandy Thompson will get extra value from her tutoring effect. But special mention goes to Jim Culver, as the blog Rite Of Seeking made an excellent case for their pairing in their Big Relic Jim article (source:)
To summaries what said over there, Jim is the only investigator that can take Dr. Elli Horowitz and whose signature card is a relic (that doesn't start the game in your play area already), and to whom Enchanted Blade works nicely if it didn't occupy an arcane slot.