It is inaccurate to say that one brand of memory is good and another not. What makes the difference is whether the individual model of memory is compatible with your Mac or not.
Kingston for example is a good memory manufacturer. However out of their 8,000 or so models, only 3 or 4 individual modules will be compatible with your machine. Kingston Apple-compatible memory part numbers all start with KTA- Their generic ValueRAM memory (KVR-) series is by and large not Mac compatible (although good memory for PC motherboards). So when you ask "Is Kingston or Viking or GVP memory good for my Mac" there is no way to give an accurate answer.
Apple holds quite tightly to the JEDEC specifications, including the accurate setting of the Serial Presence Detect (SPD) values. Many PC Generic memory manufacturers don't bother to set all the SPD values correctly, so while their RAM may be nominally correct (PC3200, 2.5V 184 pin non-ECC DDR 400 MHz DIMM) they may not be compatible
Different Macs also vary in their tolerance to off-spec memory. Your Dual G5 is relatively more tolerant, iMac G5's are very intolerant of off-spec memory. A problem comes in when you upgrade OS or firmware version -- OS10.4 Tiger tightened the adherence to the specifications, and some off-spec RAM that previously 'squeaked' under the test and was working, failed when the machines were upgraded to Tiger.
Your best bet is to buy from a reputable seller who tests and guarantees compatibility with your model Mac, offers a lifetime warranty, and a no-cost return if it doesn't work.
My bias is to avoid brands and resellers who do not state Mac compatibility, and to avoid resellers who charge a 15% restocking fee if it doesn't work and you want a refund.
Thanks
Trevor
CanadaRAM.com