If you want something a bit closer to Starfox, rather than an all-range flight arena, try Rogue Flight. It definitely evokes the power fantasy feeling, living up the classic arcade trope of “one ship being readied on a mission to save humanity”. There’s some very big-name voice actor work in it, as well.

Another good game for the “power fantasy” trope, though it’s a bit more outside the target, is Ace Combat 7. Or, perhaps any games in the series, but this one is pretty accessible. The combat is close to what you’d get in X-Wing/Tie-Fighter, but with fighter planes. It breaks from realism a little bit where needed to make the stunts fun. And, the story very much orients around the silent player character being “scary tough” in a fight, to the point enemy fighters are retreating just from seeing your wing markings.