Only Lincoln and Washington merit being on any "best of" presidents list.
Everyone else (well sort of - not the total losers and crooks) depends on their time period. Coolidge, Clinton, and Cleveland, for example, were great presidents for their time period. Any of them in period that was, to be it most directly, very important, would have been failures. But as post-crisis peacetime presidents, they excelled. Similarly, if Grant had been president during the Civil War, it would have ended in the middle of 1862 at the latest. But he was not the president at the time he would have been most effective.
A more interesting question is to consider most underrated and overrated presidents. This thread has mentioned Andrew Jackson and James K. Polk, two bloodthirsty warmongers who remain at the top of many historical rankings of presidents despite being repulsive and vicious.