DCS has combat oriented stuff but I don’t know if it has actual missions to use the weapons.

DCS literally stands for Digital Combat Simulator, it’s a combat sim all right. The thing though is that it has a very high difficulty curve, and it’s more of a thinking game than an action one, you spend minutes setting up ground attack shots and even dogfighting is more about thinking and energy retention and stuff instead of twitchy reflex stuff.

The free DCS module is actually a pretty good one to start with, but mind the difficulty curve. While Ace Combat is like “missile incoming, turn sharp to dodge”, DCS is “boom - you’re dead”. At least in the campaign, set up the plane to drop flares constantly and stay above 4000.