Dragon's lair.

Fallout 3. Because I finally get to see some in game action but I can't have the characters' heads showing and it crashes as soon as I get to the one year later part. Two claps from the Liam Neeson character and goodbye game.
"Clap on, clap off...."

There wasn't a time when I was actually annoyed by the difficulty of a game. I did go ARRRRGGGHH in Cave Story when I first got through the last, secret level with most of my health intact, only to have the game freeze during the final boss battle.

ArmA, because it's a one big bug. OFP ftw.

This one race in Crackdown is getting me a bit agitated..
The only recent game that's made me go a bit nuts was Mirror's Edge. I couldn't pass the demo so I said screw this, I'm not buying a game where I can't even pass the demo!

RC missions in GTA:VC and GTA:SA. Especially the mission in VC where you have to drop bombs on escaping speedboats from an extremely heavy RC biplane.
Also KotOR2, although that was more of an I-can't-believe-they-actually-released-this-garbage-when-it's-in-pre-alpha-state-ARRRGH!

The arcade version was even better.
A recent game that made go crazy was Black. On hard level it can get actually hard, specially the last battle.

Yeah, thats the kind of thing that happens when the publisher decides to cut 6months from the development schedule to meet a christmas release date that frankly wouldn't make much difference for a game with Star Wars in the title

How is The Movies? It is going for $3 at gogamer.com and I was wondering if I should get it, I am intrigued by it but I have a lot of games to play so I don't want to get it if it's not worth it, I am thinking getting The Movies, Prey, and Stranglehold for $3 each. It would come out to $15 total with shipping included.

For $3 then defintely, if you like either management kind of games or moderately creative film making them it's definitely worth it, especially if you can get the stunts & effects expansion because that adds a lot.
The biggest problem I had with it was the relative lack of freedom. All the films you make are assembled from a selection of pre-built scenes that you drop actors, extra & props into. You get a lot of options with the combination of a lot of scenes to pick from, custom placement & movement of the camera and custom editing but I was really hoping for something a bit more like 'actor 1 start at this point, run to this point and then fall over as if shot'. You just have to make that up from the pre-made scenes so it can get a bit repetitive but the good part is that you can chose to film the parts of the scene designated for extras and drop your main actors into the extras slots to make some more variation.
This video is a fairly good example, both good and bad parts and is also good if you're a fan of the Hitman games (another series I'd buy in a second from GOG, hint hint)

I've also owned it and I quite enjoyed it. Can definetly eat away an afternoon or night if you aren't careful. Never got the expansion myself but I'd second aliasalpha and say The movies definetly worth $3.

Syberia. The third time in a row I had to go back to the 'sage's' for them to let me get away in the damned train I cried, laughed and uninstalled. Every time I see the box I remember the good parts and wonder if I'd be able to get through that again.
And Half-Life 2. Zombie areas are so boring that everytime I reached one I just stopped playing for even weeks. The ridiculous conversations other people had with themselves also made me quit from time to time.

Ravenholm in Half-Life 2 is one of the best level which I played in games. Also I like burning zombies and hearing their screams. Yes, I am a sadistic person. :)

@Barelyhomosapien, @Aliasalpha
Thanks guys, I guess I'll just have to get it then!

Any Prince of Persia game, apart from the newest one. I'm amazed that I've managed to retrieve all buttons for my keyboard...