Ok, I've been going a bit crazy with downloading these speed demo movies lately. They provide me with a glimpse of some great titles which I'll never otherwise have the opportunity to play or finish. It would be great if these guys didn't skip the intro and cutscenes but I guess that's why they call them speed demos. Anyway, if you got the bandwidth, I highly recommend taking a look!
http://speeddemosarchive.com/GameList.html
I have all the videos for Legend of Zelda: Wind Waker (it contains all the cutscenes and story too, and the artwork is FANTASTIC), and Resident Evil 4 (this game looks fantastic, although no cutsenes so you don't know what's going on).
I'm sure these speed demos would be incredibly useful for game designers as a reference for what other designers throw at players in the variety and complexity of puzzles throughout a game.