Far Cry I have completely maxed out on mine and it produces great frame rates.
CS:S is sub-par at best. The graphics aren't so great, compared to CoD or Vietcong.
I also see a marked performance increase after upgrading to 1GB. Nothing substantial, but noticeable. I guess it was worth it.