Various studies agree that Buchanan, and Andrew Johnson, were the worst. Only three studies include G. W. Bush. The rank him from a high of 18 and a low of 36, far from the worst.
One can not speak to surplus and deficit as a measure of Presidential effectiveness as it is a one year figure. People seem to want to discount that the country has been on a war footing since 2003.