Just to be clear for future people reading this, your title said the M2 Mini could not play smoothly multiple clips of 6K ProRes unless the viewer is in "better performance". In fact your clips were 6k ProRes RAW HQ. That was not mentioned in the Apple statement you cited, nor did Apple reference a given playback mode.
"Regular" ProRes is a different codec with different decoding requirements than ProRes RAW HQ. The computational burden of decoding and playing back regular ProRes is quite low. It is likely an entry-level M2 Mac Mini could play back two streams of 8k/24 ProRes 422.
By contrast the computational burden of decoding and playing back ProRes RAW is higher. In general it is quite efficient relative to certain difficult variants such as 4k/24 Sony XAVC-S, but it's less efficient than regular ProRes. ProRes RAW is true Bayer-format RAW and requires demosaicing by the playback computer. ProRes RAW HQ has an even higher data rate but is not needed for most applications.
6k material has about 2x the pixels per frame as 4k, so in general the compute and I/O burden of playback is about 2x higher than 4k, assuming both use the same codec and bitrate. FCP 10.6.5 on my old 2017 iMac 27 can play three streams of 4k/24 ProRes RAW without any dropped frames with the viewer in high quality mode. In better performance mode it can play at least 10 streams of 4k/24 ProRes RAW without any dropped frames.
My contrast my M2 Pro Mac Mini can play nine streams of 4k/24 ProRes RAW without any dropped frames in high quality mode. In better performance mode it can play so many streams I didn't have time to test that fully.
I think most serious professionals who edit multiple streams of 6k ProRes RAW HQ would not expect an entry-level M2 machine to handle that perfectly unless the viewer was set to "better performance". Most people in that position would get at least an M2 Pro machine.
The 4070Ti GPU costs more than the entire base M2 machine and it consumes up to 285 watts. By contrast the entire M2 Mac Mini machine consumes a peak of 50 watts.
You previously asked how could you know what Mac machine configuration could handle what type of workflow without trying them out. We collectively have lots of machines and some of us would be willing to run tests for you.
I have an M1 Ultra Mac studio, M1 Max MacBook Pro 16, M2 Pro Mac Mini, 2017 iMac 27, and 2019 MacBook Pro 16. I regularly edit multiple streams of 4k ProRes RAW, 6k BRAW and 8k REDRAW using FCP. If you have a specific FCP workflow you want tested, let me know.