Only a lefty would think of FDR as "near great". He'll come down dramatically as time goes by.
I think FDR was a "great" President, and I'm about as conservative as one can be. Under FDR and his leadership (in particular, his Lend-Lease), we became the superpower.
His social policies will be debated, but he will remain high in the rankings because during a period of great national distress, he held the heart and sole of the nation in his hands and carried them safely through. The impact of that may be lost on the general publics impression, but historians will always rate it highly.