I've been playing Spyro a lot lately. I played only the Insomniac games in the PS1 age, and occasionally play them every now and again. Recently I took up later games that I missed or had very little exposure to. Also nah, you won't be a furfag from it. Dragons don't have fur
The first game is purely exploration. You'll mostly be going around collecting and it's somewhat barebones compared to the sequels.
2 and 3 added some formula to the levels and hubs. Exploration and platforming is still a major element, but there's a lot of minigames and challenges to play with to collect one of the other MacGuffins.
Year of the Dragon, the third game, is probably my personal favorite. It just feels like the top of the Insomniac games and their trilogy was the top of the series.
Enter the Dragonfly was handed off to a company as their first game, rushed for Christmas, and is basically in late alpha when released. You can guess how that is. I hear it's not even possible to 100% it.
Hero's Tail seems like there was an honest effort, but is kind of weird how it took the Medival style and made it very Disney feeling. I would probably have liked it more if it didn't have a lot of problems of its own. First one to not have the original cast or Copeland doing the ost.
I only had Season of Flame for the portable games, and it seemed pretty bad when I recently tried to replay it. Otherwise I don't really have experience with those ones.
Legend of Spyro trilogy is a reboot yeah. Tries to go into story heavy stuff (while having not much of a story) and dumped money in voice acting. Sparx is bad comic relief, combat is apparently God of War for kids and next to no strategy beyond don't get hit. Spyro is a treated like a special snowflake. Cynder is common in furry porn but it's okay, she won't make you furry either. Probably.
The last of Legends plays differently from 1 and 2, especially in that it has co-op that made playing it actually kind of fun with a friend, it was bad, and went full on LotR with Hunter being Legolas and Spyro is throughout Legends voiced by Elijah Wood. There were some free flight good ideas, but with lots of bad execution invisible walls and ceilings everywhere for forced platforming… and you're tethered to your partner so it becomes very difficult.
Spyro's Kingdom was going to be a bloody M rated edgelord MMO or something, but they realized that was a dumb idea and just went with an MMO, and then it eventually degraded to rebooting as Skylanders. It's not a Spyro game.
Looking back, I wish we could've had bloody Spyro, it would've been hilarious to mock, but Skylanders isn't Spyro enough to really say anything about.
I'd suggest play the Insomniac games, Year of the Dragon if you only want to play one. Legend of Spyro is good for a few laughs but the gameplay is really dull since they try to be cinematic.