Still... That ignores one of the biggest advantages of air power, reconnaissance.
Which civ version was it that allowed you to do reconnaissance missions?
If you put a fighter on patrol, it will provide visibility from that location, so that's pretty much a reconnaissance mission.
I preferred Civ 5's approach, where you had visibility out from any airbase to the range of the planes there.
Currently playing game as USA and I've seen surprisingly good air unit use by AI.
My two nuclear strikes by using bombers were intercepted by fighters and another one got downed by a jet fighter.
My units were also attacked by jet bombers.
Maybe there was a sneaky change in the code last patch, or ai is just very inconsistent on its air power use.
Pretty sure it's just randomness. The AI will build planes post R&F, and if they're on patrol they'll respond appropriately i.e. intercept incoming planes. The AI will also use Bombers, it just won't use them every game. Mostly when it uses Bombers, it uses them to pillage districts
The AI weakness in airplanes is mostly:
(1) Low prioritization. Even with the high cost of modern units, on higher levels the AI could have more planes earlier than it does, if they ranked higher in the build priority order. I'd say AA Units have been given zero priority, but then since the other AI don't build many planes, I don't build AA Units either.
(2) Not using Fighter-class planes to attack units, even though they're more effective at this than Bomber-class planes.
(3) Not recognizing the threat posed by defending enemy airplanes, and therefore not bringing AA Units or Fighter cover escort.
(4) Continuing to bomb cities that have already been reduced to zero health points, rather than shifting to new targets.
Note that even if this is solved, I'm not sure air combat in Civ 6 will ever be as interesting as it was in Civ 5. The whole patrol mechanism is a tedious and unnecessary step relative to the Civ 5 approach. And if the AI is ever taught to build AA units, air units will likely be immediately obsoleted, as the high cost of building them (including having to lay aerodromes) won't be worth it once the AI starts using AA units