So, now I don't know why I was thinking it was so awesome, but it is distinct from the text-over-the-landscape thing, and gets you into the story: [link]
'Out Of Gas'
Buffista Movies 7: Brides for 7 Samurai
A place to talk about movies--old and new, good and bad, high art and high cheese. It's the place to place your kittens on the award winners, gossip about upcoming fims and discuss DVD releases and extras. Spoiler policy: White font all plot-related discussion until a movie's been in wide release two weeks, and keep the major HSQ in white font until two weeks after the video/DVD release.
I like James Bond title sequences in general. Often better than the movie they are attached to.
It's the end credits of Seven that made a big impact on me. Just by running the text the other way, I think, but it was jarring. I was working in a movie theater when it came out, so I saw all the end credits while sweeping up and had opinions about most of them, that's the one that really sticks in my memory all these years later.
IIRC, the most clever of the classic Disney opening sequences was 101 Dalmatians, with the spots proliferating everywhere.
I remember loving the opening credits for He Got Game.
I'm in the middle of a very strange movie from the late '60s, Skidoo. The opening "credits" appear on a TV screen for about 5 seconds. Then a remote clicks, and the TV changes channels -- and that's it. No more opening credits.
(How strange? Groucho Marx as a mob boss strange. Jackie Gleason on an LSD trip strange.)
Eddie Murphy's Coming to America -- the camera swooping down across an utterly charming miniature landscape of the prince's home nation under a sweetly soaring Ladysmith Black Mambazo song.
Soapdish is another great one made of pure fun, and I second Kathy's vote for 101 Dalmatians.
I can't remember opening credits. Oh! I know! The Charlie Hunnam Nicholas Nicolby with the gorgeous miniatures!
We had a blog post about best end credits a while back. [link]
TV Show credits True Blood gets my vote.
Modern films? Having seen the opening credits for this movie recently, I'd have to put The Inside Job opening credit sequence in there. I really liked it and different from Spike Lee's previous movies.
The opening sequence for Do the Right Thing has Rosie Perez at her absolute finest.