There must the a name for this phenomenon. Like, the more you know, the less faith you have in it actually working. I'm pretty sure everyone feels this way about their work. I just asked my partner if it's the same with her (non-tech) job and she said yes, she can't believe it works at all. Arthur C. Clarke's Travel by Wire comes to mind too.