questions:
Are you in the USA or other parts of the world?
Do you have a budget in mind?
Musical, fast, and tight - are all wrong terms to describe subwoofers. I guess what you're looking to describe type of woofer design, specifically low Q/qts :
https://www.bestcaraudio.com/speaker-q-and-how-it-affects-sound-quality/
space is limited? Do you have a specific size idea? Woofer size doesn't describe the sub's size well. You could have horn-loaded subs with 10" which takes half room or fairly small sealed subs with a 15" driver.