The rarity of offer sheets in the NHL adds to their mystique, with past dramatic instances like Joe Sakic's and Brian Burke's creating buzz. Recent successful double offer sheets by the St. Louis Blues may open doors for more in the future, impacting player contracts and team dynamics.