You had a good intuition for the relation between Cd and BC. However, this link explains the real relation between these two variables:
https://sites.google.com/site/technicalarchery/technical-discussions-1/drag-coefficients-of-bullets-arrows-and-spears
I'm a gamer myself, and very much into...