I've worked with ... 4 in over 25 years that I would work with again. They were helpful middlemen. Only 2 landed me anything, but I know the other 2 put in some effort and things just didn't work out. There's been dozens I've spoken with and wasted far too much time with.

tldr - they do exist, but in very short supply (like many skilled/talented people in most industries)