Are soy products good or bad for you?

cam asked: I hear conflicting reports about soy products and their effect on health. What is the truth?