The only gap in millimmeters I can see here is between 600mm and 800mm.
https://www.nikonusa.com/en/nikon-p.../index.page#!/tag:lR8:Z Mount Digital Cameras
But from 12mm to 600mm there's no gap at all in terms of focal length.
You can probably switch systems if you want that one lens, switch to whatever mount supports it. Or adapt the lens to Z.
And while Nikon offers a 50mm macro and a 105mm macro, they don't offer a longer macro (still not available from 3rd parties), or a tilt-shift macro (available from TTArtisan)
There is a new Zhongyi Optics (ZY Optics) Mitakon APO 200mm f/4 macro 1X full-frame lens for Nikon F + Z mount.
https://nikonrumors.com/2023/09/03/weekly-nikon-news-flash-744.aspx/
___
On the topic as such, I think you have to separate and formulate very precisely here.
That there is a lack of third-party lens suppliers in the Z-mount, or a lack at the frequency of the output, is certainly not true.
That may be true if you are exclusively fixated on Sigma, Tamron and Co. as third-party suppliers, or only consider lenses with AF, but as a general statement it is simply wrong.
There are plenty of lenses for the Z-mount from third-party suppliers and new lenses are constantly being released.
However, with the exception of Viltrox and a few Sigma/Tamron offerings for the Z-mount, these are mostly manual focus lenses.
Personally, I am not at all interested in Sigma or Tamron, but much more in high quality manual focus lenses from Cosina/ Voigtlander, or Laowa, as an additional complement to my Nikon Z-optics.
So from my point of view, the thread title couldn't be more wrong, because there are much more interesting optics for the Z-mount from third party suppliers than I have financial resources for.
Apart from that, you can adapt pretty much any lens for the Z-mount.
So if you want, you can use not only Nikkor Z-mount lenses, but also dozens of third-party lenses for Z-mount, you can also adapt every Sony E-mount lens, if you want and with very good results also in terms of AF behavior.
So if your horizon starts with autofocus only and ends with Sigma/Tamron in the third-party sector, and you hardly notice anything else on the market, you can easily adapt Sigma/Tamron optics made for E-mount.
As a Z-mount owner, you basically have access to the largest range of lenses available, because almost everything can be adapted, which is not possible the other way around.
However, if you want to use the complete, or a lot of the Sigma/Tamron lineup natively, Sony is certainly the better choice.
Even if lenses like the 35-150 for the Z-mount are now released, Nikon will continue to be more restrictive here.
I have been involved in photography, off and on, for a good 45 years and in all that time I have never used a mount that allows me such a variety of different optics.
This wasn't even the case in the days of M42.
Accordingly, with my Z camera I can not only use what is now a very extensive native Z lens range from Nikon, but also adapt pretty much anything that comes to mind.
All my old lenses from more than 6 decades of lens history, several of which have not been usable without loss for decades (Canon FD), my remaining Mamiya 645 medium format lenses, even all of my father's heirlooms from the M42 era.
Even one of my two Rollei V/S Heidosmat MC 90mm f/2.4 lenses (Rollei Twin slide projector lenses) can be used on my Z camera via an M52 - M42 helicoid adapter.
I could use the entire F lens program as a gap filler, any E-mount lens I want to add.
If there's one problem that doesn't exist in the Z-mount, it's the variety of optics that you can use, which is unique.