You have asked the age-old question- and there is no firm answer, it's a trade-off.
Heavier, higher BC bullets will take longer to get to the target. Yes- they'll buck the wind better, but they still have a longer time of flight.
The smaller bullets with a less attractive BC won't buck the wind as well- but will get to the target faster- and thus, are influenced by wind and gravity for a shorter period of time.
I've always opted for the heavy/high BC bullets- but there are those that don't.
You also have to consider that external ballistic theory is just that- theory- and if your rifle doesn't "like" a given bullet for whatever reason, you're limited to the bullet and load/velocity it shoots accurately. IOW, it might look great on paper, but...