Confused about Soy?

It seems like everyone is confused about soy.  You can find just as .  Do a google search and you will literally find content claiming soy lowers cholesterol levels but