Larry Brown
You could try to argue that Brown is more than a one-season wonder. Of course, you could also say he was a one-game wonder. Brown actually made the NFL’s All-Rookie Team in 1991. But he’s best known for his two interceptions in Super Bowl XXX while playing for the Cowboys. Dallas turned those two interceptions into two touchdowns in their 27-17 win over the Steelers.
Naturally, the Super Bowl MVP was in demand when he hit the free-agent market the following year, landing a five-year, $12.5 million deal from the Raiders. One year into that contract, he was relegated to a backup role. Later, he was suspended for “conduct detrimental to the team” and eventually waived by the Raiders. From there on out, his only job was providing depth to teams with a bad secondary.