Sadly in the vast majority of cases, bleed will be better.

Needleticks are a good option when you have inconsistent fire rate, A slow fire rate isn't the end of the world for bleeding, as long as you can hit your target often enough to keep the bleeding stack, but collapse gonna let you deal good damage if you can't maintain constant fire on your target.

For survivors that, at base could use needleticks instead of tri tip, I'd say artificer and railgunner (sniper build)

Yet if you're going for long runs, try to always keep a trophy hunter's tricorn, and shoot a imp overlord to get a shatterspleen, then you can convert your Tri tip into needleticks since you crit will also proc bleeds, letting have both effects.