I think it's apt that Gasper Noe's Enter the Void gets such prominence at the video's end - it's the longest inclusion by far - since a great case could be made for it being the greatest title sequence in cinematic history. Alas, for now, just enjoy the video and bathe in all the beautiful images, eye-popping concepts and inventive typefaces. There's about 80 (edit: this page tells me it's 73?) films and TV shows represented here - I like the inclusion of TV since that is where a lot of the most interesting, daring and visually striking title design work is being created these days since most films don't feel like including much more than a barren title card - although I may have missed some during that bit before Se7en where it goes all speedy and haywire.
But seriously, enough of me yammering on about how great this is. Just watch. Remember, the larger version can be found at Art of the Title.