There are many names out there that make excellent ram, G.Skill, Mushkin, Patriot, Corsair, Crucial, ect. In many cases it depends on availability and price. If you find a good name brand for a low price then it is usually best to get one of them. I went with warranty, availability, and price. Mushkin will replace on of my Dimms if it ever goes bad.
GSkill and Corsair are what I use now. The Crucial Ballistix were good but they had massive problems with the DDR2 1066 so I haven't used them since and the cost isn't worth it either. OCZ is too picky on motherboards, when they work, they work very well, when they don't it's ugly.