The Axis is, for my EDC purposes, the best lock available.
The CBBL is too stiff. (I actually prefer the original BBL to CBBL, but I recognize the benefits of the cage for knives like the Manix)
The Compression lock isn't quite as comfortable an action in my hand, though it's pretty darn close.
At the end of the day, though, there are more factors than just the lock. Add the hole-opening system to the compression lock, and you beat any thumb-stud opener. Add Spyderco's attention to engineering and steel heat-treatment, and you've got the best knives out there. Para2 M390 is as close as it gets to perfection at the moment, though I'm eager for something with a bit more blade in the compression lock with super-steel.
Even though I don't really like the midlock enough to choose it over any of the others, quite a few of my favourite knives use it: Caly 3.5, Large Persian, Spyderhawk, Lava. Same for liner/framelocks: Rock Lobster, Military, Cricket, Sage2.
Sometimes I think Spyderco deliberately randomizes locks, features, and steels just to keep me buying more knives...