Interesting!
Me having the same config (X3870 X2, Q6600, 4GB RAM, WD-Raptor HDD) and half of the settings on Hi or Normal), with 75% 'viewdistance' just doing fine... Not that fluid like COD, but playable indeed. Oh, I'm runing it on XP Prof X64! Just for the record! ;)