I've got a 1 Gb GTS250 and I can't get much improvement, I'm sure that it's down to the age of the game and it's as good as it's going to get! The graphics card can only do what's possible with what goes in.
I've yet to try Conus' widescreen mod which may yeild some eye candy moving up from stock 1024x768.
As usual, I could be wrong and would love to be set straight.