Chris McGuinness says the city showed why it is seen as one of the world’s great sporting destinations over a remarkable 11 days