The amp used in a system is always the limiting factor in terms of power output. The power rating of the cab is useful because it is usually a thermal rating, ie at which point the voice coils will overheat, not necessarily the point at which the bass speakers will smash themselves apart beyond their maximum excursion at low frequencies. So a higher rated cab is more assuring that it will continue to work fine at the maximum output of your head. The maximum sound pressure is determined by the sensitivity of the cab and power output of the head. For instance if the sensitivity of the cab is 96db @ 1W @ 1m and the power output of the head is 100W the maximum volume will be 116db, off the top of my head i think this is worked out by sensitivity + 10log(power max). This means the sensitivity of the cab is far more important in terms of maximum volume than the power output of the head, as an increase in 10db of sensitivity is the same as going from a 100W to a 1000W amp.
Obviously at the end of the day quality is far more important than max spl, as anything over 90db is potentially doing damage to your hearing anyway, so if you have a sensitive cab you don't really want to be outputting more than 1W in a home environment anyway.
That's one reason horn loaded cabs are so popular in venues, they can add 10db of sensitivity when using the same driver compared with a sealed unit, and ported subs tend to be loud at one boomy frequency so lack quality.
Sorry for the long post.