You might want to check out Chorus, it’s on sale super cheap on GOG right now. It’s an action game with some levels on foot and others in space.

An honorable mention is Star Wars Battlefront 2 (classic) - maybe not exactly what you want, but it has space combat where most of the action is with ship dogfights, where you can also attack the opposing capital ship and disable its core systems to win the match. The whole single player game ensures you’ll get one hell of a power fantasy as the ace/hero, even on harder difficulties.