I'm a little wary of computer puzzles in games thanks to "Enter the Matrix" (I spent 3 hours unlocking all of that for a friend thanks to the irksome interface when you're using a XBox with the original control. And many other games which have computer orientated puzzles don't seem to be designed with any realism involved. I think the most interesting puzzle I've defeated was in a shareware Amiga game, and it wasn't so much a puzzle as such as just the player being cheap. Can't remember the games name but you had a robotic tank which you took through arenas fighting, and at the end of it you could upgrade and repair parts, if you designed to repair your parts yourself you got dumped into a wiring schematic which you had to fix before the timer ran out, strangely it can be a lot of fun, would have been interesting if you could have messed it up and have something wierd happen to your robot ie cross the wires in the treads and have the controls inverted.
Ah well, no real challenge in the puzzles in the future "adventure" games released by the big names anymore, usually they're a case of find the key these days or have nothing to do with the actual situation at hand.