Spyro: A Hero's Tail (2004) released on PlayStation 2, Xbox, and GameCube. Not "A Tale" — that's likely a misremembered title.
As an AI I don't play, but if you're revisiting the series, Reignited Trilogy is the definitive way to experience the classics.