Indeed so, this is why the smaller and lighter gear is so desirable amongst many enthusiasts, Lumix really helps making the likes of their new lenses, typically smallest and lightest. Who would want the old style 100mm f2.8 macros when they have the ~300g at 1/2 the weight and smaller?
The new lightweight Lumix lenses are OK, but there are definitely compromises to make them as small as they are. The most obvious one is max aperture, but IQ is also not up to the very highest levels. I love my 14-28 for example, but it's not in the same league optically as the much bigger and heavier Sigma 12-24 f2.8 Art. Similarly, the Lumix 28-200 is weak in IQ compared to the bigger and heavier Tamron 28-200. In the case of the 14-28, it's a compromise I'm OK with. But the 28-200 falls under my personal "good enough" threshold.
And as to macro lenses - if they are being used for true macro work, the weight is unlikely to be a factor since you're probably working on a tripod. The Sigma 105mm f2.8 macro (which I've recently acquired) is breathtaking in its optical performance. Certainly the best macro lens I've ever used.
I also said before you won't see again a Lumix body size bigger than S5ii size, if anything the market is pushing the other way.
I wouldn't be so sure of that. I'd be surprised if the new S1 isn't a little larger than the S5n(probably similar to the Leica SL3). I doubt it will be as big as the old S1, but I think to get the handling and controls up to the level of cameras like the Z8, they need to make it a big bigger than the S5.
And in any case, not all mirrorless cameras are small - the obvious example is the Nikon Z8 and it gets rave reviews.
Personally I think Canon/Nikon/Sony/Fuji are poor with aesthetics. That retro Nikon zfc and the similar retro Fujis are pretty abysmal for comparison.
I'm glad you added "personally", since these things really can be very personal. The Fuji cameras in my view have very poor dial layout and I find they give me cramp after a while. They are definitely not for me. Nikon Z cameras however are very similar to Lumix in my view in their handling, but they fall short in menus and general feature availability and ease of use. I'm out of touch with Canon these days, but back in DSLR days, they were excellent. Sony - well, I think in fact that the latest bodies have come on a long way from their early days. I don't think they are much different from Lumix in essential ways today. The A7RV even has a dual tilt screen like the old S1.
And the Zfc - I don't much about that, but a good friend who is a very experienced photographer has the Zf and he absolutely raves about its feel and handling. But we're back to personal opinion once more I guess.
Yeah that'll probably mean I'll probably own an S9 someday.
I suspect if you are comfortable without an EVF, and don't take stills shots in artificial lighting, then the S9 is a fine camera!