Here are the shocks I’ve used extensively:
Fox Van RC
Bog standard Fox DHX Five coil
Pushed DHX Five Coil
Fox Float RP23 with and without Boost Valve
CCDB
The Van RC is great especially when set up specifically for you, your bike and your riding style, but you really do need to know what it is you want it to do before the tuners can set it up perfectly. If all you can say is, just get the best compromise then that’s what you’ll get.
The standard DHX5 is now obsolete and it was fine but the Push tuning does a lot for it, largely because, as with the Van RC above, it gets set up for you and your bike.
The Boost Valve RP23s are excellent IMO, but they do feel quite different to either the coil dampers highlighted above and the non-BV RP23.
The CCDB is brilliant; it has a simple unfussy, composed feel to it, nothing dramatic, in many ways it makes the action of the suspension ‘disappear’ , if that makes sense. It’s kind of like removing a layer of dust or cloud from between you and the terrain your bike is tracking so that you can feel what’s going on without there being any extra information from the damper itself.
So yes, the CCDB is worth it to me. The only way you’re going to find out yourself is the try one! 😈