I find if the ambient temperature of the room is above 80 degrees (as it has a tendency to get in New Orleans), the 9800XT is the noisiest part of my G5.
Otherwise, even while playing 3D intensive games, the whole machine produces a quiet whirring sound at the worst.