Clearly Truman is #1. He won the war with Japan, stopped Soviet-supported aggression in Korea, created the Marshall Plan and NATO which stopped Soviet expansion in Europe, and recognized the State of Israel. He was helped by some sympathetic Republicans who didn’t believe in obstruction for obstruction’s sake.
Clearly Bush 43 is at the bottom. He got the US into two never-ending wars, one of which is now the longest war in US history. He turned a huge budget surplus into a massive budget deficit with nothing to show for it except those wars. His economic policies led first to a huge decline in the value of the US dollar and then a complete economic collapse in his last months in office. And his Road Map for Peace demanded essentially nothing of Israel’s enemies other than words. There were no successes to balance off these disasters.
One can argue about the relative position of most of the rest but it should be noted that the three most antagonistic to Israel were (in order of decreasing antagonism) Eisenhower, Ford, and Bush 41. (Carter’s hostility didn’t manifest itself until after he left office; while in office he was actually better than Ford.)
Johnson gets credit for tipping Israel off to the planned Arab attack in 1967, not responding to the USS Liberty attack, and making Israel into a US ally. I would rank Ford as second from the bottom as he had no foreign or domestic policy successes, was incredibly hostile towards Israel, and offered no response to a terrorist attack carried out on the streets of Washington DC by agents of a hostile foreign government (but one with a lot of apologists in Washington).