IMO Nikon Z mount bodies are excellent and very functional in terms of ergonomics and button layout especially the tilt screen and two front function buttons. But their primes are quite large and bland cylinders.
While Sony has plenty of native and 3rd party primes are pretty compact. Even Canon RF 35/1.8 and RF 85/2 are smaller, have IS and macroish. I hope the next batch of Nikon non-S F1.8 or F2 lenses are compact.
Nikon have chosen a more systematic and structured rollout for the Z than either Canon for RF or Sony FE.
Don't get me wrong, there are great lenses in all 3 systems, so I don't want to get into petty brand wars.
But as a counter point to your big primes/bland cylinders point, it seems to me Nikon are following a path which could be described as follows
Pro Fast Lenses - the 2.8 trio, the 50 1.2 and upcoming 85 1.2
Pro More Compact Lenses - the f4 zooms, the f1.8 primes
All these are S line. Then there are a couple of non-S 'kit zooms' which are still very good given their size and zoom range.
Conversely, it feels to me Canon RF and Sony FE are a bit of a mish-mash.
Canon - primes include a couple of pro 1.2s but then a random assortment of f1.8 or f2 with macro or not with macro, consumer-kit grade or prosumer grade. Zooms include a super pro 28-70 f2 but the 70-200 2.8 is a bit less pro with its compact telescoping and no TC capability.
Sony have the advantage of an extensive lens line in FE but the disadvantage that most of them aren't particularly exciting - a lot of the Sony FEs before the last couple of years feel to me like DSLR era designs with the adapter built in. Their branding is bafflingly complex: Sony, Sony-Zeiss, ZA Zeiss, G, GM - all sorts of confusing overlaps. They seem to be launching GM primes that compete directly with their own ZA primes (eg ZA 35 1.4 vs GM 35 1.4?). But some of the primes launched recently seem impressive to me - the 1.4s are relatively compact and seem to be optically excellent.
As a loyal Nikon user, I'll happily admit there are designs I
personally prefer in Canon or Sony. I'm not a pro, so although my Z70-200 2.8 is arguably the world's best 70-200 2.8, I'd prefer the small Canon. As Lance says, the Z primes are exceptional, but I'd prefer the relatively compact Sony 1.4s. But, overall, I think the Z system is excellent for the high end prosumer market it was launched for and is building out for the Pro market. I know nothing about video, but I also get the impression the S lines are very video-suited. For example, I think one reason the Nikon S 'bland cylinder' primes and zooms are not so compact is that they've been engineered for zero or near zero focus breathing. I couldn't care less really, but for a video user its probably easier than having to remember which of the more mixed/muddled Canon and Sony lenses are more or less video friendly.