Well my faith based understanding of screwed joints (machine tools, instruments, cues)
Is the truism that "screws tension, dowels locate".
I do tend to make my modified (flat root) 3/8"- 10 G10 only joints a bit "snugger" than might be advisable from an engineering standpoint, but i cut them so about 3/16" to 1/4" of the barrel protrudes into the shaft for radial alignment. That should be a very snug fit. (It can require a clean-up cut on the barrel before installation and sizing other parts - the threads aren't always dead concentric with the un-threaded portion.)
The screw, radially, has very little effect on the stiffness of the cue. It is all down to the mating surfaces of the joint, and how much tension the screw can apply to keep them there. Joint screws in almost any material are shockingly easy to bend if the joint is not tight.
smt