The crazy looking corkscrew that Maynard James Keenan used in the documentary film "Blood Into Wine" is called the Cork Pops Shark Corkscrew.
There are similar cockscrews called the Lazy Fish Corkscrew Wine Opener. The Original Lazy Fish Corkscrew opener is from England and can typically be bought for $40 to $50 (that's if you can find it.. check Ebay). The Original version will say "Lazy Fish" on the corkscrew opener itself. You can find a similiar Pisces Fish Corkscrew at amazon for about $30.
Video of the Lazy Fish Corkscrew bottle opener: http://www.youtube.com/watch?v=6H2vt-tzJFk