1024MB of ram could not handle new games with full details and I fell big impact after buying another 1 gig of ram in SH4 also.
My radeon x1900xt 256MB is enought to play SH4 with all seting full with one exception - volumetric fog is a reall fps killer in that game. In Drivers I also maxed all up AA x6 and so on. And this card is much older than GF8800.
8800 is updated 7600GT? it must be huge update because 8800 support DX10