Herschel Walker is the only one that comes to mind but that was long ago.
The Vikings thought they were adding the last piece to a Super Bowl champion - instead Walker did little for them, and instead they added the pieces to a Cowboys 3X Super Bowl Champion, while the Vikes continue to languish in the Never Won A Super Bowl Club.