I really like the Dunedain Pipe. It's one of those cards that isn't powerful on its own, but really shines as a multiplier when used with other forms of card draw. It's hard to call the Pipe card draw on it's own because it doesn't increase the number of cards in your hand, but what it does is allow you to see an extra card every turn, to help dig through your deck and find those cards you need.
Used by itself as the only source of card draw isn't going to be much use, eventually you'll play your cards or want to keep events in hand etc and then not feel the need to use it. But combine it with other forms of consistent draw - Beravor, Gléowine, Deep Knowledge, Galadriel, Prepare for Battle - and it suddenly feels there is always an option there you're not going to need the next few turns and don't mind burying for the chance at another key card.
Worthy of note is that because the card you give up is placed on the bottom of your deck rather than discarded, it's easier to see it again than it may be otherwise. It doesn't rely on having discard pile shenanigans, just the super draw you may already be taking, or something to shuffle up your draw pile which may or may not be part of your deck anyway. Things like Master of the Forge, Haleth, or Drinking Song are prime candidates here.
In different contexts this can be better than pure card draw as well - through the Ring Maker cycle this can be invaluable in still allowing to see more of the deck would on its own, without increasing the hand size and suffering the negative effects therein. And in quests where running out of your deck is a loss, this again allows you to keep the deck full while seeing more of it. Usually pure draw is better, but it's worth noting the corner cases.
Beravor is the obvious natural pairing, but it's also mentioning Thurindir here as he becomes a splashable hero that can provide card cycling to go with his side quest shenanigans. For bonus points, pick Prepare for Battle as the starting quest and watch him become a budget Beravor that can still quest.
The Pipe will work with any Dunedain hero, as long as you've got Lore access. While it can go onto allies, having at least one Dunedain hero stops it being a dead card until you find the rest of the draw - you really don't want to rely on another card to get your draw engine running. But there are plenty of other Dunedain characters for the extra copies to attach to - notably Thalion you may have already if running Thurindir, and Northern Tracker is a staple of many decks,
The final note here is - it's repeatable, non-unique, and there are plenty of Dunedain characters onto which it can attach. You can use all copies you draw as long as you've got the characters for it to go onto, and then can use all three in a turn to just power cycle through your deck without caring who else is using it as well.