functional idiot

A person who isn't real bright, but is capable, and sometimes very good, at enough things in life to succeed.

Tim is a functional idiot. He may be a little slow, but he's a great mechanic, and is well liked around the shop.