@Doozy: Liberation CD32 speech is OK. Hammy, with bad accents, but it still adds to the atmosphere. Rather like Beneath a Steel Sky CD32.
Some intros not mentioned yet that are cool:
Virtual GP: pre-rendered spinning car
Roadkill CD32: pre-rendered cars smashing into each other
Sensi CD32: Very evocative music against a photo backdrop (Italy 1938 I believe)