For opening sequence, whether or not there are any actual credits in it, I nominate Lord of the Rings: Fellowship of the Ring (original theater release version; there is an extended version but I don’t think the added bits are necessary for an intro). Here is an explanation from a channel called The Art of Storytelling that explains it better than I could.
