I think cavendish is unfairly maligned by many smokers, some of whom like to boast how they would never smoke cavendish or allow only "uncased" or "natural" tobacco to pass their lips (showing an amusing degree of ignorance by claiming such a thing). The problem is that too many American blenders seem to have figured out how to boost their profits by taking lesser quality tobacco, subjecting it to the cavendish process and then dousing it in goopy syrups, thus producing the notorious genre of bulk "American aromatics."
But cavendish doesn't have to be that way. For one thing, there are plenty of good aromatics out there that use higher quality leaf as well as better quality flavoring agents (applied in reasonable amounts). Unflavored black cavendish can make a delicious base tobacco, and when added judiciously to an English, Balkan or even a Va/Per the effect can be profound. Two Friend's "Redwood," for instance (which was created by C. Tarler and Greg Pease) is one of the best presentations of cavendish I've ever experienced. It's basically a very stout Va/Per, but a generous quantity of red virginia cavendish is added to increase the sweetness and smooth out the smoke. This ability to "smooth out" a blend is, in my mind, the best attribute of cavendish. It can tie a blend together, reduce bite and tame any harshness. As others have pointed out, it's often been used in latakia-forward blends for much the same reason. 965 and the Balkan Sobranie White are two classic examples, with Northwoods being a great contemporary English mixture that gets it right.
It's also worth noting that one can subject just about any tobacco to the cavendish process. For instance, I believe that the original Frog Morton gets its unique qualities from subjecting both the virginias and the latakia to the process. A lot of guys are convinced that the Frog is some kind of closet aromatic, but I sincerely believe (based on some home blending experiments) that they simply applied the cavendish process to the latakia, creating an exceedingly sweet and mild English that's different from everything else on the market. I'm not a huge fan of the Frog, btw, because it is FAR too mild, but I do appreciate it for what it is.
Anyhow, enough of my rambling! You asked for our favorite cavendishes, so here's my short list:
Northwoods (English)
Redwood (Va/Per)
Shortcut to Mushrooms (latakia-based aromatic)
Haddo's Delight (Va/Per)
Smokies Smoke-Ease (a Gatlin-Burlier house Englsih blend that is heavy on the orientals)
Autumn Evening (red VA cavendish-based aromatic)