Check out Ian Davis’ prosthetic hand.

www.youtube.com/watch?v=kixS5Sy0F9s

In at least one of his videos, he demonstrates a ‘lock under load’ feature that enables him to lift fairly heavy objects.

I don’t think you’d get any magic superhuman powers, but it’s pretty badass regardless.