So many opinions on which brand is "best". What seems to ring true for everyone is subs are good, and more are better. One might conclude that matching the size, type, location, and integration of the subs with your room and speakers matters more than the brand.
I currently own subs from Rythmik, SVS, and PSA. All work well for music. I've also owned some other subs including HSU, Sunfire, and even Klipsch.
Some do sound "bad". Klipsch and Sunfire were not very good. Not just not "musical", but not very good for anything. They made noise, but that was about it. I didn't think the HSU subs were very robust, but I had some older models. They may have gotten better.
If I were to generalize, I'd say stick to sealed subs, get as many (up to 4 or 5) as you can afford and have room for, and experiment with placement and tuning.
All of the subs I own are "musical" and integrate well with my mains. This is in large part due to the fact that I have 4 of them throughout my room in my main system and have a massive amount of headroom. They don't call attention to themselves in any way when there isn't a lot of bass content and can deliver the goods in a very visceral way, much like what you experience with live music.
I have a couple of secondary systems where I only have one subwoofer. While it doesn't rival my main system in terms of scale, I have an inexpensive SVS SB12-NSD sealed sub and Harbeth P3ESRs in a small room and it rivals my main system in terms of listening pleasure.
Using the right tool in the right way for the job at hands matters more than which brand in my experience.