I find it interesting that LBJ made the list. I have always been leery of his presidency but I was too young to remember it. The earliest president I remember is his successor, Nixon. TBH, I have to rely on others' assessments of LBJ and Nixon. On the other hand, by the time Carter was in office, I was old enough to observe for myself. My opinion of Carter didn't deteriorate until about 1979 when inflation was running rampant (no comparison to the 2020s) and the hostage crisis along with the botched attempt to rescue them. When Reagan ran against Carter in 1980, he was being branded as a war monger by the media. Apparently, Iran was buying into the hype because as it became apparent that they were going to have to deal with Reagan, only then was meaningful progress being made in that crisis. The hostages were on their way home within a half hour of Reagan's inauguration. Being 15-16 years old, I saw for myself what went down.
I'm sure the other historical presidents had their problems and I won't argue with Bill... He's done way more research on the topic than I will likely do. My opinion on Carter is subjective but it's based on personal memory.
One thing I'll agree with Bill on... Carter and Biden aren't even close to comparable.