If the OP is only interested in a compact, that TG6 would be ideal
Yes, the title of the thread is "compact camera for macro," so that is what I take the subject of the thread to be--what compact gives you the best macro shots? Full-sized macro setups with flash and diffuser can be pretty cumbersome, so there may be lots of situations where photographers want something more compact.
However, the TG6 strikes me as far from "ideal." I have the TG4 which, though older, is very similar to the TG6. The sensor is small and the image quality is so so, and there is no full manual mode. Even in aperture priority mode you only get to select from three different aperture settings; there is no shutter priority mode. But it does appear to have the best in class magnification power – having both a microscope and super microscope mode. So if you are photographing really small stuff, e.g. springtails, then it may be your best option. (I tried a few springtail shots and they were only half decent – I never got the full critter in sharp focus even with bracketing--though the camera usually selected an f4.9 aperture).
But what if you are going to be focusing on larger subjects, e.g. 1 cm or larger? In that event high magnification is less of a priority, and other compacts with larger sensors and better image quality might yield better results even if they offer less magnification. So I don't see the TG6 as the end of the discussion. There are a variety of larger sensor compacts available.