Carter isn't generally reviled for being too smart. The number one thing that he's reviled for (maybe unfairly) is planning and botching a hostage rescue attempt that turned out to be pointless later when the hostages were freed by their captors.
Strictly speaking, I think he was reviled because the rescue attempt came late and didn't work. He made a joke within the last year - when announcing his cancer diagnosis, I think - about how he'd have been reelected if he had sent a few more helicopters on that mission, and that that would have been a mixed blessing for him personally. Both points were true, I think.
(no idea why you were downvoted)
One of the better presidents was William Henry Harrison; didn't last long enough to mess things up.