As KmH points out, normally an in-lens silent wave/ultrasonic/hypersonic focusing motor lens is faster to focus than a lens that uses the in-body focusing motor on the consumer and mid-level Nikon cameras. However, in the case of the Tamron 28-75, virtually every,single user who has had both models of the lens reports that the screw-driven version (the one with NO motor in the lens) is significantly faster at autofocusing. Louder, but noticeably faster. So, that's a bit of unexpected behavior, particular to the Tamron 28-75.
In terms of sheer longevity...lenses without an in-lens motor seem to have a slight edge over AF-S, HSM, in-lens motor lenses when measured in periods of a decade or decade and a half--speaking in terms of anecdotal experience and hundreds of people.