Price, CPU performance, RAM, storage, networking, software support outlook.
I mean really though unless you have a lot of time I don't think there's anything close to worth leaving the software support of Raspberry Pi for.
For that I'd really point you towards the links in the article, as that was really what it was supposed to do :D As I mentioned to another person in the comments, this was literally supposed to be a recap of the boards I tested, with links to in-depth benchmark results for each of the boards, with the ability to then filter and compare against around 100 other SBCs that I own and have tested in a controlled manner. Software support is a very tricky one though, sadly. I have a few ideas for little things like being able to search for Armbian support, but others would need a long hard think!
We posted that at the same time!!
Rpi and also nvidia jetson I would add.
Yeah, the Pi has a very interesting looking mini-screen addon too.
https://www.waveshare.com/product/cm4-disp-base-2.8a.htm
I think being able to switch between a phone and desktop is a great use-case for SBC. Important to be able to attach a power bank and the real bottleneck to adoption: a telco addon.
Some sort of vibration absorbing case would also be great with a few different varieties around too: https://www.gttwireless.com/raspberry-pi-outdoors/ https://github.com/NebraLtd/IP67-Enclosure
You could take that SBC with you on a bike, car, around the home, to the worksite. Even a mobile web server for temporary gatherings placed on a high vantage point. Signage is also an important area for SBCs.
I'd wager on Polymarket that Apple will end up doing something in this space.