If the neck is not sufficiently rigid, the amount of mass absolutely affects the frequency of resonant vibrations of the neck like a tuning fork. That's why the Fat Finger devices mentioned earlier can affect the dead spots on a bass.
But whether the headstock style on a guitar makes an audible difference is questionable.
And regardless, any difference would be most pronounced with less rigid, less stable necks that many of us deliberately avoid by buying from W.