Piston engine aircraft use the same fuel we do, yes, it is 100 octane, (some) but most up here have an STC for 90 octane car gas. Airplanes are also low compression, most under 7-1. The high octane fuel is needed because of the low RPM. Aircraft engines also have a really really tight lobe sep too, LOL.
In reality, tuning is tuning, cars run at altitude, in different humidity just like small planes do, not saying it is exact, but similar. The planes are also more complicated, thus the better understanding of how the fine tune/ram air effect, (air intakes are in the cowl getting direct wash) temperature, humidity, and manifold pressure, (vacuum in the auto world) effect performance. ( most have digital EGT guages).
It's not the same, but the same, if that makes sense.
You are right about the greater potential of the air. All effected my humidity, altitude, temperature, etc. Water injection, for example, creates a denser charge of air in two ways, one, the air is replaced by water, two, the air is cooled/compacted by the direct cooling effect of the water mist. This also allows leaner mixtures (especially if the fuel temp is hot) to get the same amount of power. Kinda an example, a long time ago the military used water injection to decrease take off distance by making more power, while mixture settings on take off were full rich, no additional fuel was added with the water mist, not only did they make a substantial bit more power, but cylinder/exhaust temperatures were lowered.....
Totally off the subject of the original OP's question, but it's interesting to me. (tuning goes far beyond AF, timing, etc.
Like Moper said, the greater potential of the air to make power is what makes the ram air work, and the greater potential, will actually raise the vacuum. (well, probably not by a measurable amount really, but it will) This will happen until the boost from the ram air is equalized with the intake vacuum, which probably wouldn't happen with the systems out there, until WOT, if that.