Its first level is an innocent discard effect, but the more you invest in the enchantment, the better the results
It also hides the card you searched for in exile, keeping it safe from discard effects
As for what Tifa making it into the deck while the other characters have to settle for booster packs really means, there's a chance someone at Square Enix made that decision based on which in-game romance is canon
This has led to decks like Blue-Red Murktide pop up a deck that would traditionally struggle to deal with a creature like Tarmogoyf, but now you have a clean, one-mana answer to deal with it
The only downside is that you need to keep a creature alive in addition to the Enchantment in order to maintain that banishment, but Sheltered by Ghosts more than makes up for this by giving the creature in question Ward 2, for a total package that does more than other cards for less mana