The Commonwealth Games were at risk of dying, says James Toney, but Glasgow did enough to raise hope for the future