It has been several years since the lever corkscrew design first catapulted to popularity, going from a gadget that was almost strictly for big wine drinkers to a staple in any home that also has a bottle or two of red. The style was popularized by the Metrokane Rabbit corkscrew, but there are any number of similarly designed openers available today. The last time that Cook's Illustrated put these openers to the test was about 9 years ago and in their most recent issue, they decided that it was time to revisit them and see how some of the more expensive brands stacked up to some of the less expensive newcomers.
Their "ultimate opener" was the Screwpull Trigger from Le Creuset, which has a unique mechanism that adds an extra grip to the cork, ensuring a fast and clean uncorking. But out of the 13 models, 12 made a respectable showing, so CI's conclusion seems to be that you will do fine with almost any lever-style wine opener. Their advice, if you're not going for their "ultimate" model, is to try to select openers with longer handles, which will make removing the corks easier.