Vito compliments Tom as Consigliere, but says that Sonny was a bad Don. As others have opined, Sonny was basically a fighter who was a temporary fix in Vito's place. That he let his emotions govern his actions that led to his death should be a salient indication of his deficiency as a Don.