The most common (negative) example of this I've seen is when founders sell the VC on the solution, not the problem they're solving.
Everything starts out fine (you have a VC who is really excited to help you build and sell product X, even if they don't really care about problem Y). But then you realise that actually, the market wants you to pivot slightly to product Z to solve the same problem Y.
And that's when the VC pivots from being helpful to harmful.
There are probably multiple other examples of how founders can influence the value-add of their VCs, but that's the big one that springs to my mind. And I bet it accounts for 90% of the 'harmful' instances.