In practice, the Q control just allows more low-end output. If you want to hear the difference, run a pink noise tone, that is probably your best bet for perceiving a difference. As for 'tightness,' the Q control doesn't change group delay significantly, so it's not a filter. If you add a filter to create the same effect on the response, you would see a spike of group delay.
Higher Q will loosen things up and lower Q will tighten things up. However, and TLS Guy will probably disagree, but the Q of a low-frequency speaker system is not an audible property outside its effects on the frequency response. It's not a matter of 'tightness' in bass either. Here is the group delay of a high Q subwoofer:
... and it is not bad. Pretty much below 10ms above 40 Hz and below 20ms above 30 Hz. The audible consequence of the system Q will be heard in the frequency response, and
it will be obvious.