This is really interesting, I think we've experienced some very different companies! Where I currently worked, I've been the "inside source" for 4 people (2 of which I initially reached out to first), all of them were rejected :(
A Cover Letter / CV / "Inside Source" isn't (usually) going to get you the job. It's just going to get your foot in the door.