Boris Johnson, London's colourful mayor, expressed his sadness and relief as the London 2012 Games came to an end.