There are neodynium subs that are good on music. People use DD Z's in sound quality cars. Like actual competing cars. There was that old critical mass sub that was a neo and was like revered for its SQ, iirc. I got to see one of those in person, they are cool subs. I've designed for one or two of them before. Neos aren't all designed purely to be SPL woofers. They are super duper wicked expensive, though. And you do usually see neo's in SPL applications, to be fair lol.
For what it's worth, I'd say someone who knows what they are doing and has good EQ could make nearly any sub on the market play flat from 20-80hz at 120dB for an RTA competition. We certainly don't need neodymium for that job and certainly not at the price of the stuff ever since corporate welfare to """green""" energy spiked demand.
I've seen that CM woofer and I don't think it's anything special. Good, but grossly overpriced just to give the impression that it was something ultra premium. That companies marketing was super cringe inducing bafflegab and I remember when internal shots of some of their extreme priced amps came out they were identical to several Korean/Chinese boards on the market. The shame of it all is that that company had enough retards with deep pockets on the hook that they could have probably hired some top engineers and actually advanced the industry.
Otherwise, if weight savings isn't utmost priority and any cost, stuff like the TC 3HP neo version or even the Fi BL and BTL could do the same thing with ferrite. NRT/Beehive/Teardrop designs from TC and Aura may require neodymium but they don't use a whole lot of it and I haven't even looked into that enough to know if that couldn't be done with other materials.
The point is, that the big value of neodymium is going to be in numbers chasing once you hit the absolute limits of what ceramic can do and just need to brute force more motor force into the job.
To come at it another way, and anecdotally, I run the Shocker Sigs. Switching from the 05 sig to neo sig typically gains 0.1 to 1.0dB (I would say 1 full dB is very unusual) but at 4x the price per motor (from Thilo, and 15 years ago pricing). IF you have an extreme build and are sitting neck in neck at dB Drag finals sure you'd pay a few grand more for subs to try to gain a few tenths, by the time you're at world finals you've probably already found every other gain to be had and gaining the same amount with more power may be impractical, more costly, or perhaps even impossible if you're at compression on your subs. That's the guys who bought those motors when they came out and the value was there. I doubt OP will never buy an SPL meter, will not put hundreds of hours into testing and tweaking, and will not ever be at the point where he is looking to gain a few more tenths at any cost. At his likely budget and power level the difference between say DD95XX and DD-Z in price could buy him better sound/output/performance being spent almost anywhere.
And lastly, say what you like but my Sig neos are extremely peaky. They can be forced to play flat but at the expense of a lot of output and it gets worse the less cone area you put on that motor. If flat and wide bandwidth were my goal I could do it a lot cheaper with a lot of other stuff.
Conversely 12" cone on the '05 ferrite motor is almost impossible to make not sound good. I wish my old ass were up to wrestling heavy subs anymore I'd be running those in every vehicle.