What you should be asking yourself, is how the different materials will affect the weight and balance of the cue. There's a big difference between the brass and titanium in weight. You left out aluminum, and G10, too.
You'd be hard pressed to actually determine whether a different pin material will make the cue hit any better or worse, or even much differently, aside from the weight factor.