Horsepower vs pressure depends on flow rate. The more flow at any pressure, the more horsepower required. Most airbrushes have a pretty low max flow rate, so airbrush compressors do not need a lot of power.
Further, one way to reduce power needed is to reduce leakage. Wrapping threaded connections with teflon thread aided the pressure I can achieve with my pretty wimpy Iwata compressor.