Bond of Friendship may be the most powerful individual card in the entirety of the card pool. While there are some very real restrictions, the benefits far outweigh them to the point where against standard quests I can struggle, I can take on the Nightmare version and feel comfortable.
In Emmental's review below he covers restrictions quite well, so I won't go through those again. The benefits though are worth expanding upon, because while the extra hero and resource are powerful in and of themselves, there are some nuances I think make interesting discussion points, and also one I'd like to add.
The extra hero and hero action are not just a 33% increase in your output - they offer some interesting extra choices by allowing a hero to shore up the weaknesses of the other three. For example, playing an ally bouncing deck with Lothíriel, Éomer, and Imrahil is a powerful combination, but card draw is an issue long term with all the allies leaving play. Playing the same style of deck with the Bond of Friendship contract allows taking another hero who can help with card draw, essentially eliminating the weakness of the core idea of the deck right from the start and not requiring you to find the card you need to do it from your deck.
Another example to this point is a Hobbit deck - their chief weakness is being able to defend the enemies they want to engage. Tom is answer within the archetype, but if you're taking Tom, one of Sam, Merry, or Pippin normally can't be in the deck. Playing in contract allows you to take the extra hero to shore up the defensive weakness - usually it's Tom and SpMerry using Thorongil to get back to his Tactics version, but you could also use Beregond with the three classic hobbits and keep your threat right where it starts.
Another benefit of the extra hero is with global benefits - More dwarves for Dáin to benefit, starting with 4 dwarves (or 5 if using Bombur) to proc Thorin, or more Dale characters for Brand. It also allows global boosts to have more targets to start with - things like Sword that was Broken or Faramir can be worth playing earlier if you can because they have more targets in play.
The benefit the contract offers that gets overlooked most is the fact that you have access to cards from each sphere, and all that that entails. You don't need to make difficult decisions about which sphere to leave out, and to which element of game play you no longer have access. If the Hero combination you want doesn't have a lore hero, you don't need to give up on healing, scrying, or card draw, or settle for less efficient options. While you can still play those staples using A Good Harvest or the Songs, it requires multiple card combo's, and enough card draw to make it work. In a Bond of Friendship, you just have access to those right from the start.
There are some very powerful staples in each sphere that will always make a deck stronger, or more resilient. Things like Steward of Gondor or Faramir; A Test of Will or The Galadhrim's Greeting; Feint or Gondorian Shield; Gléowine or Warden of Healing. Being able to take all of them, even with the limitation of 2x, is going to make a deck handle a more broad set of situations than you may otherwise.
The 10 card restriction per sphere I've found is actually a really enjoyable part of deck building - I want this card, what have I got in other spheres that can do the same thing? Or which of my other cards in this sphere have replacements in other spheres? The chain reaction of moving cards in and out when deck building is delightfully puzzling, I enjoy building Bond decks as a result.
I'll also leave you with this thought - you can now take Beravor, and still have 3 hero actions without needing to find any readying. The restrictions are enough to stop it from being easy mode, but it's not far off - an extra resource and two extra cards per turn, with access to all four spheres. Insanely strong.