I imagine some of the difficulties involved in doing what the OP suggests ("Why not make a hand that can spin like a drill? Fingers that can close in a fist on either side of the hand?") could be overcome. The nervous impulses that apply the extensor muscles to open the hand probably still exist as even the human fingers reach their mechanical limit. It would be a matter of training.
Having a hand that spins like a drill depends upon how it is connected to the body and how the data is transmited into the prosthetic.
People who are familiar with the popular 1970s TV series
The Six Million Dollar Man recall that Colonel Austin was rebuilt after a horrific crash using the science of bionics, giving him extra strength & speed. How did THAT work?
That series was based on a Martin Caidin novel called
Cyborg. In Caidin's novel the bionics limbs had some abilities the TV show lacked (while also "lacking" something the TV show added). The bionics hand in the novel had a tiny CO2 powered dart gun hidden in one finger. With this Austin could kill with a poison dart from a distance. Hidden in secret compartments in the legs was a tiny bottle of compressed air for underwater use, and a tiny radio transceiver. Small collapsable swim fins were fitted into the soles of his bionics feet, so all sorts of cool stuff might be imagined. In the 1970s the TV series' budget prohibited the employment of above devices, so the TV hero lacked them. He did, however, have an actual working bionic eye with nightvision plus a handydandy zoom, something the book character didn't have.
Probably because amputees don't see the prosthetic as a chance to "upgrade." They want normal hands, not weird Dr. Strangelove hands.
And cost.
You know, in the end, I think Fistful pretty much nailed it.