`Happy and glorious' Olympics come to rocking end