Yes those 3 are still considered the 3 best pro grade Nikon zoom lenses for covering that focal length range.
But their is also a Budget Trinity:
Nikon 12-24mm f/4G ED IF AF-S DX Nikkor Zoom Lens
Nikon 24-85mm f/2.8-4.0D IF AF Zoom Nikkor Lens
Nikon 80-200mm f/2.8D ED AF Zoom Nikkor Lens
. . . since the 24-85 doesn't make the most sense on DX, the 12-24 is a DX lens, and two of those lenses require a focusing motor. Am I mistaken?
Why doesn't the AF 24-85 mm f/2.8-4D make sense on a DX body?
I really like and use the 1:2 macro capability it has from 35 mm to 85 mm.
I use the lens on a D50 and a D200 - both DX cameras.
Yes the 2 AF-D lenses would be manual AF -
except when on the Nikon D1, D1x, D1H, D2H, D2X, D2HS, D2XS, D3, D3s, D3X, D4, D4S, D50, D70, D70s, D80, D90, D100, D200, D300, D300s, D600, D610, D700, D750, D800, D800E, D810, D7000, D7100.
The only Nikon DSLRs ever made (so far) without an AF motor in the camera is a much shorter list - D40, D40x, D60, D3000, D3100, D3200, D3300, D5000, D5100, D5200, D5300 - All of Nikon's lower entry-level tier of compact DSLRs.