I've heard that APAP modes work only for people on low to moderate pressures. Is this true?

Actually, the opposite is true.

AutoSet technology can provide greater benefits for people who need higher pressures.