Remember I spoke with a company that produces and sells the stuff, so it could be said they're bias toward the product. What I found impressive was this man I spoke with was really into cars, oils etc, and knew what he was talking about.
What impressed me was he mentioned Mobil 1 and Redline, and said there were different schools of thought on just how much to use. He stated that Redline really loads their oils up with it, and it did have added benefits in his opinion. He could have just as easily pushed WS2 aka Tungsten disulfide which costs a lot more, but felt Moly was better because it was lighter and that's why its added to engine oil.
Like anything else, opinions vary, and many people feel the oil companies got it right. He said used in the 1 teaspoon - 1 table spoon amount it wouldn't harm or off balance the oil in anyway, and would enhance it. As with anything too much is never a good thing.