There's the closeup lens (I'd have to dig mine out to check the strength and design) that fits to the front of the 75mm lens, and a huge acrylic lens (attached) that spreads in front of the viewfinder and rangefinder windows. The viewfinder is still offset to the side and above the lens axis, so although you can focus, and the frame lines see the adjusted framing, this is only strictly true for a flat subject.
With three dimensional subjects you will have to deal with two axis parallax. If you are familiar with the prism that is used on the taking lens of a Rollei/Yashica twin-lens viewing lens for vertical offset, the big side lens on the Mamiya adapter does the same thing with the diagonal offset of the M6.
The nice thing with the closeup lens is that there is no exposure correction, unless you get in your own light. The camera meter looks though the big side lens too.
Does it work? Yes, subject to the limits of close-up and parallax. You don't really focus the camera - more advance/retract the camera to find focus with closeup lenses, so a focus rail would be a good addition to a tripod.
It's big, and the side lens is vulnerable to damage.
If you only have an M6 and do a lot of natural close-ups and need portability, it might be worth it. I'd probably use my Mamiya C or the 4x5 since I have that option.