Thanks for the time effort required for doing the tests.
I do similar tests prior to buying a camera with full size RAW images from at least three different online reviews.
Then after I have the camera do RAW IQ tests to verify IQ of the camera purchased.
But more importantly to 'me' I do print quality tests as the 100% pixel peeping imperfections are not as apparent in prints unless doing large prints.
I've found that with 20MP and higher, if a image looks good at 10MP any print I would want would look good. That's with the ZS100 RAW images I've been able to get even at full tele; e.g., my post
HERE.
The ZS100 for its size, zoom range, and price is a good general purpose/ travel 'picture' taker.
It is, but it just depends on how fussy you are about image quality and features. For example, let's look at smaller crops of the images I've posted: ...
TZ100, 200mm equiv, small crop
IMO more of 'how practical' one wants to be; i.e.
How large would prints need to be when viewed at normal viewing distance see the differences between TZ100 and RX100M6?
Or the resolution/ size of a display viewed at normal viewing distance to view the full image to see differences between TZ100 and RX100M?
I fully understand for comparison purposes to use the same RAW PP settings, however with a little USM and CA correction your TZ100 200mm equiv. JPG image can improve the image:

Left is your OP TZ100 200mm equiv. • Right my tweaked version
Yes doing the same enhancements to the RX100M6 would probably have similar improvements, but still for practical purposes the mast majority of ZS100 users would never notice/ miss the differences between the ZS100/ RX100M6.
Hence as to your statement of "TX100 is very poor at 200m" in your OP not entirely true, and only at 100% pixel peeping, or possibly with vary large high quality prints would one see a difference at normal viewing distances.
For myself there's far more to a good "photograph" than digital perfection.
Again some previous ZS100 images at 250mm equiv. that I would not consider "very poor".

800 ISO; POF was women
Two images below were RAW images downloaded from Imaging Resource ZS100 review prior to purchasing the ZS100.

91mm/ 250mm equiv. lens test (full 20MP for the 100% Peepers)
The main reason of my post is that for that for those who may not know better by reading your OP may incorrectly dismiss the ZS100 as having poor image quality.