Pretty nice, but, I'll have to agree on what Wanoha said, 100%.
Funnily enough HL2 was also my 'it won't need to get much nicer than this, honestly?'
I've seen Crysis at a friends place. Monster graphics, but the enemy AI wasn't especially impressive. Good, but nothing much above the line-cut.
Incidentally I still love all the classics, myself. Half-Life, Age of Wonders, Baldur's Gate 2, Warcraft 3, The Total War series... can hardly wait for Shogun 2. (Medieval 2 is still a pretty good game despite the awkward factional AI etc.)
Many new games out are pretty damn good to without relying on graphics alone. RecetTear is win, games like Mass Effect, Dragon Age and Fallout 3 (loved F1 and F2 too, btw) keep entertaining me. Their grapics are not killer-line either.
Besides, I don't want to play any shooter any time that is soo realistic in graphics that I'd think I'd shot some guy in RL. No thanks, I preffer my pixelated foes dropping with little horror, tyvm.
Also there is EVE. Wonderful graphics, but still so much content. The Enemy AI is yet to be beaten... wait a sec...