Any word is offensive if you use it in a manner to cause offence.

A muppet is a kids puppet with a hand in it, very entertaining, but if I call you a muppet I’m saying you’re all mouth and no brains.

Most insults for stupidity are archaic medical terms describing a lack of normal capacity.