I was at the game when he hit the GS. I had realized it was the first pitch he had seen in the majors. It was a cool story. He'll always have that cool story, but he was never major leagu material, and certainly not for a franchise like the Boston Red Sox.
It was a Joe Hardy moment, and he never hit another HR. His powers were gone right after that swing.