I totally get what you mean, Spyro made flying feel magical, and it’s hard to find games that really capture that same feeling. Lair had the right idea but didn’t quite stick the landing.
If you’re still chasing that dream, a few games do flying mounts or dragon riding really well. World of Warcraft: Dragonflight added dynamic flying that actually feels smooth and fun, it’s not just gliding, you get real momentum and control. For pure dragon combat, Century: Age of Ashes is all about aerial battles on dragons, and it’s surprisingly fast and responsive.
If you’re into older games, Panzer Dragoon Orta and Divinity II: Ego Draconis both let you fly as a dragon, though they’re more niche. And Dragon’s Dogma has one short dragon-riding moment that’s super cool, even if it’s not a full feature.