To admirers, Biden will remain one of the most consequential one-term presidents in US history – to detractors, he was undone by a fatal flaw