On a similar vein to this, the useless genius who does absolutely nothing but either sleep/play games/do nothing helpful but is kept around like a trump card for that one special moment of usefulness.

Even more if their special skill is a weird split personality that is hypercompetent/strong/incapable of getting anything wrong and apparently no one ever could've figured out how to do it without them (despite the solution being just punch harder).