Some of the benchmarks with Motion, which uses Apple's Core Image effects engine are better on the (slower) 2600XT than they are on the (faster) 8800GT. So either this has something to do with the fact that Apple's Core Image engine is far more heavily optimized for ATI chips, or that OS X's nVidia 8800GT driver's are not very well done. So apps that rely heavily on Apple's Core Image effects may perform better on ATI graphics than nVidia at the moment.
Either way, there is the potential for improvement, since the hardware in the 8800GT is far more capable than the 2600XT - and presumably there are no special commands being used in the ATI chips that the nVidia can't do without expending more cycles.
Whether any improvement is to be developed however is up to Apple (and probably nVidia, too).