It's a resonance in the entire circuit. That is, if you change the amplifier gain, either of the resistor values, or either of the capacitor values in the Sallen Key circuit, the response will change.
It's not easy to explain intuitively how the response changes. It's not as easy as it is for instance with an LCR circuit, where the LC controls the frequency, and the R affects the Q. Unfortunately, one has to set up the transfer response for the circuit, and grind through the s algebra.
But you've noticed the capacitor ratio influences mainly Q. The RC product influences mainly the bandwidth. That's about as intuitive as you're going to get.