Just saying "referrals are worthless" or "referrals are useful" doesn't mean much without specifying the type of referral. Obviously if you're talking directly to a hiring manager who's willing to bypass HR, it's much likelier you'll end up with a job than if you're talking to someone who sees an open position on another team and says he'll flag your resume on their ATS if you apply.