I am far from an expert on this subject. I have recently taken up schutezen rifle shooting, with breach seated, cast, plain base bullets. There is a lot more to it than I know, but when you examine the 200 yard targets, you sometimes notice nose high strikes, which is an indication to back off your powder charge to reduce rpm. Like every shooting sport higher velocity tends to get you a flatter trajectory and a shorter time of flight to minimize wind drift, so most fellas try to find a twist rate to not overspin the bullets, but minimize flight time. -Of course there is an effective maximum velocity that one can attain due to the plain based lead bullets, without leading.
I have learned that between about 800 and 1800 fps or so is a very unstable velocity zone for most bullets, and they are supposedly the most affected by wind at these speeds. Unfortunately that is the velocity zone for the old black powder cartridges. In this zone the short nose "Pope" style bullets seem to perform the best. These bullets are characterized by really short flat noses, and the ones I shoot are tapered to fit the throat of my chamber better. So bullet shape, weight, length all these things need to be optimized for the shooting one intends to do in a rifle of a given twist.
Though recently a lot of fellas are shooting a sort of spitzer bullet. It is interesting to be on the firing line and listen to the really detailed explanations of these things, most of which is beyond my reach.
Seems the happiest place for the bullet to be is *just* stabilized, as in this way the bullet shape follows the arc of trajectory.