I think the maximum RAM that Final Cut can use is 4 GB. I’m not positive, it might be slightly less. (I know that version 4.5 could use 2.5 GB…I thought it went up since then but I’m not positive.)
Even though the G5 chip and Tiger are both 64-bit, Final Cut Pro does not yet take full advantage of that fact. So its RAM-usage is still capped.
BUT, that’s just Final Cut. If you want to have FCP, Photoshop, Motion, and all the iLife programs running at once then you’ll make use of a lot of RAM even if any single program isn’t taking up more than 1 or 2 GBs. So I could still see the use in having 4 to 6 GB of RAM. But 10? I don’t think a video editor on a single computer could get much use out of that yet.