It takes pretty big gaps in BC to really make a big difference. Wind deflection maybe grows a little bit, it takes a few more clicks of elevation, but unless you get into a dramatically different trajectory arc shape or push towards being trans-sonic, it's just a different number to dial to. The further you push the target distance out the more you see things creep. Wind reading and rangefinding errors cause bigger and bigger misses, but within 600yd or so with most modern bottleneck cartridges it's about the same story regardless of the bullet used.
A lower BC bullet that shoots tighter is almost always preferable (from a hit probability standpoint) than a higher BC bullet that shoots worse. The best of both worlds is when the higher BC bullet shoots great for you.
There is the argument for BC/drag variability, and what I've seen is that our tipped bullets outperform OTM style bullets pretty much every time. I know there's been a bunch of AB data/FB posts out there saying the opposite-- we haven't observed that and I'm leaving it at that. Regardless, the drag variability really only shows up beyond 800yd in most situations. It takes time/distance for the variable slowing rates to manifest as vertical variation. Certainly important for ELR, but much of the effect is nearly negligible within most "practical" distances and for most targets at something like a PRS match (otherwise certain brands/types of bullets wouldn't maintain a following...). Even in the ELR world, though, you get such a magnitude of external variables that from the end-user perspective drag variability can be muddied up and hard to detect without radar.
Match your performance needs with your application and budget. Use what works best.