I absolutely loved the opening ceremony - every bit of it, even the corny parts.
Boyle did a brilliant job.
Like daisylil said - the winged cyclists were magical.
Simon Schama, a Brit living in the USA, has a long piece on the opening, a good read, in today's Daily Beast.
http://www.thedailybeast.com You'll have to scroll around for it.