I loved X-Wing Alliance the most of that flight sim series (though they were all great). And that was an example of controls done right. You had full three dimensional authority, but they also tweaked it slightly so it didn’t just feel like airplane controls. What would normal be the yaw (rudder) input actually controlled roll. And what would normally have been roll was mostly yaw, but with a subtle coordinated rolling action incorporated. It was genius because it felt otherworldly and “spaceship-y” while still retaining all the traditional directional control inputs.

Plus you could actually move freely in three dimensions.

It’s been years since I played it, but I remember really liking the flight controls in the original PS2 Batlefront II because they were very similar to the X-wing series controls.

I’ve not played the new BF2, but I have the first PS4 Battlefront and it’s flight controls are somewhere between the X-wing style and the Rogue Squadron controls. They’re not perfect, but they lean enough towards the X-wing style that I’ve enjoyed playing it.