Reading the intro to this thread, I'd have to say what I've made doesn't fit into the mechanical or electrical category, just the creative. My uncle used to run a bar which he closed recently, this left him with quite a few beer tap handles. He'd been wanting to use them as bottle openers and this is the solution I came up with.
The design is simple. One 20mm dia. stainless steel nut and one 3/8" dia. UNC Imperial 1" stainless steel bolt. Drill 8.5mm dia hole into nut, run a 3/8 tap into the hole. Cut the head off the hex head of the bolt and use a thread lock to hold place. Cut a small section from the nut such as in the images to create the final head shape.
Most beer taps use a 3/8" course thread so this design is universal and creates a unique and satisfying bottle opener!