Planescape: Torment. No opening cinematic so intrigued me as the one at the beginning of that game. Rather than simply telling the story, Torment's opening provides the player with a series of brief flashes, where the meaning of each is revealed later in the game. The catch, however, is that you have no idea what you're watching the first time you see it. Then, as you progress through the game, you think back and go, "Oh! So THAT'S why he was with that girl," and so on.
Definitely one of the most innovative uses of CGI cutscenes I've ever seen. Seriously, look it up on Youtube.
As an honorable mention, I'll also plug Oddworld: Abe's Oddysee, if only because it borderline-mocks the emerging convention of CGI exposition at the time through fourth-wall-breaking. Just when you think there's going to be some resolution, Abe goes, "So, GET ME OUTTA' HERE!," in a tone of voice that says, "What? You were expecting something more? Hell no; this is in your hands, now, so don't screw it up."
"'Casual games' are something the 'Game Industry' invented to explain away the Wii success instead of actually listening or looking at what Nintendo did. There is no 'casual strategy' from Nintendo. 'Accessible strategy', yes, but ‘casual gamers’ is just the 'Game Industry''s polite way of saying what they feel: 'retarded gamers'."
-Sean Malstrom