A Milwaukee Brewers player named Tim Unroe hit a 9th-inning pinch hit grand slam for his 1st MLB homer in a May 3, 1997 17-4 win over the Mariners in the Kingdome. He hit a total of 3 big league homers, with 11 RBIs, in 95 at-bats, 1995-2000. It got me thinking about other short-term big leaguers who did one spectacular thing in an otherwise obscure career. Phil Humber’s perfect game is a better example, but in a slightly longer career. And, Humber is in no danger of being forgotten.
The negative side of this is Ron Wright, who, as a Seattle Mariner, struck out, hit into a double play and hit into a triple play in his three MLB at-bats, on one day, April 14, 2002. Judging from this 2007 New York Times article on Wright, he recovered from the experience pretty well.
Do you have any players to add to these ranks?