I'm unsure if a flash of this BIOS would be the only change for these cards, maybe something is also needed for communication with the TPM on Mac Pros. Also, the flash module itself might be different leading to problems, but it certainly would be interesting to see the video card flashing days come back.
I bought a cheapo 6200 AGP for my PowerMac G4, and flashed it with a modified 6600 BIOS, worked right away, improved performance an awful lot, in fact (that 400MHz G4 was really stressed with the UI and the code it had to run, now everything flies, but the upgrade to a dual 450MHz G4 certainly helped, heheh). I hope we can do this soon, after someone figures out how to write a compatible video BIOS, or when ATi and Nvidia start giving us EFI based video cards for our regular PCs. This should also help bring the prices of Mac cards down.
Oh, and DaedalusHelios, it's more likely to be Adobe's fault that they can't get their products working under x64 properly, but CS2 could already address greater than 2GB of RAM under OS X and Windows, so there's no excuse in the RAM department, while other operations might not stand to gain as much from running under 64-bit, compared to running multi-threaded.