Raspbian works perfectly fine. Most of those other operating systems don’t really have the best GPIO support which is where Raspberry Pi shines. I’d just get a cheap mini pc if I wanted to run something else.
No mini PC can beat most things about the Pi, apart from performance and compatibility, the latter of which is fully the fault of the manufacturer.
Rpi is strictly suited to very specific use cases.
My new favourite tool for these situations is the Radxa X4, which is the exact dimensions of a RPi, but with an Intel x86 CPU and an onboard microcontroller to drive GPIOs.
Will checkout the radxa x4 sounds interesting.