Cloud was only a failure in terms of getting into SOLDIER and serving as a satisfactory subject for Hojo's experimentation. The latter is something anyone would hope to fail (the alternative meaning being reduced to a muttering zombie wrapped in a black shroud), and the former was negated by the revelation near the end of the game that he was stronger than anyone else ever dreamed anyway.