"Saaaayyyyy-gggaaahhhhh" and Lucasarts' efforts might be the most memorable, but a ton of console games of the 1990's had great little intro screens, not for the games themselves, but for the publishers releasing them.
Sometimes they were clever, sometimes they were funny and sometimes, in the case of EA, they've barely changed at all.
Console Splashes [Dumb Geeky Stuff]