I love film titles, I think most designers do. If you’re looking for a comprehensive collection, Steven Hill’s Movie Title Screens Page is a good place to start. While there is video, there are thousands and thousands of screencaps. Only one shot from each (and you’ll have to look past the old school web design), but it’s a good place to jump off from if you’re looking for some kind of inspiration.
And of course it’s always worth mentioning the amazing Art of the Title Sequence again.