A retired South Yorkshire miner was prevented from going home to die beside the brother he had lived with his whole life, because of a string of errors by the five organisations tasked with looking after him, an investigation has found.