Does anyone ever use one anymore? I recently had to put a center punch and pilot hole down inside of a long channel, through one object into another; it was not a job for a small hammer and an impact center punch, or a powered drill.
A Yankee Screwdriver with a drill bit chuck adapter did the job. These were common when i was a child but are now discontinued and can be found on Ebay. Be aware that different Yankee Screwdriver models require an adapter that fits that model; most adapters fit on several, but not all models.