I thought your first link would be Bloody Stupid Johnson.

The late (or at least severely delayed) Bergholt Stuttley Johnson was generally recognized as the worst inventor in the world, yet in a very specialized sense. Merely bad inventors made things that failed to operate. He wasn’t among these small fry. Any fool could make something that did absolutely nothing when you pressed the button. He scorned such fumble-fingered amateurs. Everything he built worked. It just didn’t do what it said on the box. If you wanted a small ground-to-air missile, you asked Johnson to design an ornamental fountain.