Ones I've played? As was mentioned previously, the meat circus in Psychonauts.
Ones I watched someone play, but I also got annoyed at? The mission in AC3 where you have to chase a guy down through the streets. You can't kill him, he runs really fast, and he drops coins that people try to pick...