President Cyril Ramaphosa has expressed his dismay at the state of the City of Johannesburg, saying he was "not very pleased".