Did you ever read Dick Francis? One of his detective characters has a prosthetic hand, and he's clearly done all the research because every blessed bit of it is in the story. He had to look up how to open a wine bottle, and so we get to read all about it. It's gotten all the way to charming.