The current Doom 3 is probably still Crysis 1. Bonus points if you get some of the mods that take it up a notch.

The other option is GTA IV with mods. You are pretty much guaranteed not to be able to run it all the way up with the current ridiculous mods. From my understanding, the videos floating around that show it off can't be captured from real gameplay and are actually rendered separately in a frame by frame way to even look decent.

Aside from those, there really aren't any big PC killers. Crysis was the last time devs really tried to make a bleeding edge game that rapes video cards. The industry has instead turned to optimizing games for consoles (this is why Crysis 2 isn't nearly as PC breaking as Crysis 1). There's pretty much no money in trying to outpace PC hardware so nobody is even attempting to push the envelop any more.