.40 adds cost/ shot, unless you plan on reloading, for not much gain.
Since you already have 3 9mm, why not comp either the SIG or Glock? I’ve not seen a threaded barrel for a 92 ( doesn’t mean they don’t exist, just that I’ve not seen one other than in pure competition guns). Or just port the 34 for similar results.