The opening and closing credits of films and TV shows are often the best places that utilize animation and experimental FX stuff! And in the case of opening titles are probably one of the most important parts of a film, usually being the first things people see! Nowadays animation studios are even cropping up dedicated solely to producing a film's credit sequences or opening titles in imaginative and creative ways!
A website - Art of the Title - exists as a resource collecting tons of different title sequences to draw inspiration from! Like Silent Hill Revelation, Paranorman, Ghost in the Shell, Scott Pilgrim, Adventure Time, Tekkon Kinkreet, Aeon Flux, Casino Royale and many more! Anyone interested ought to really check it out!