Executives and founders were sold on the idea that social media is good for business. But they're learning the hard way that it's not all it's cracked up to be.