I liked the opening of Forrest Gump, especially given the subtle use of very advanced CGI it took to make it.
The other opening I truly liked seems to have been inspired by it: the opening of “Le fabuleux destine d’Amelie Poutain”, in which a fly is followed around and then squashed by traffic.