I usually think of tight bass as a quality of rock and roll music. Meaning impactful, and realistic to the kick drum in particular.
GOOD bass however is broader than rock'n'roll. This is bass that is:
- Balanced with the midrange and treble
- Uncompressed
- Low distortion
- Lacking in noticeable room modes