A fantastic website with lots of recent titles too - a site you must refer to throughout.
http://www.artofthetitle.com/
Some of the youtube links don't work but if you search in youtube they will come up.
http://www.smashingmagazine.com/2008/12/19/30-unforgettable-movie-title-sequences/
These you have to look for yourselves:
http://www.imdb.com/list/2mdHt8unYqs/