Probably not, at least not without hacking the game. Typically only things which were built to use the extra RAM see any benefit, whether that's homebrew, leaked game betas which rely on the extra RAM that devkits had, or games made for the Sega Chihiro arcade platform which was basically an Xbox but with double the RAM.
There was a great article here a few months ago on this very subject, detailing getting Halo 2 to run in true HD, properly using the extra RAM of the devkit, and the engine hacks required to do so (since it basically statically allocated a handful of regions and couldn't dynamically go "oh look more RAM!"). It was a good read!
