I wrote a blog post about why I made the site at https://bret.dk/introducing-sbc-compare/ if anyone's interested, but to TL;DR it, I didn't set out to create a site like this, it was a side quest after creating the automation and database to support my reviews, which do indeed focus on the hobbyist trying to explore Raspberry Pi SBCs and their many alternatives.
I have full specifications and hardware capabilities hidden behind a feature flag at the moment as I'm working my way through adding all of that data (currently at 80 SBCs in the database, and I'm only adding those I own and have run tests on) so there should be something similar to what you're asking for soon. Thanks again!
If you fit the envelope, the Beaglebone Black has been out forever. It's not fast. It's doesn't have super modern interfaces (Displayport, PCI-E). It's not super tiny.
However, it is solid. It actually runs in the 500mA USB envelope and doesn't need a heat sink. It has eMMC so you don't have to fiddle with garbage uSD cards. It is incredibly well documented thanks to TI. It has a useful number of I/O pins (unlike the measly amount on the RPi). It has tons of the kind of basic hardware interfaces that you need to interface to things. The real time processors on it can often substitute for FPGAs. There are industrial versions for $10 more than the standard $50. And the software follows bog-standard mainline Debian rather than being some weird, undocumented, bodged-up thing that needs to boot from the GPU.
Pricing is quite different from supplier to supplier. Usually around 50 - 100 € Here are a couple suppliers for NXP boards:
Toradex (Switzerland): https://www.toradex.com/
Phytec (Germany / India): https://www.phytec.com/products/
Variscite (Taiwan): https://variscite.com/
Intel boards usually cost around 100 € - 150 €
I for one learned way too late that an ESP32 (whichever model really), despite being massively more complicated, will typically have a much smaller quiescent current in deep sleep than a 555 timer - even the CMOS implementation.
I've already found my board, but this is not my last battery-powered project.
Before getting into benchmarks I would actually look which hardware capabilities a specific SoC supports first (eDP, HDMI or LVDS, USB ports, i2c, GPIO pins etc). Then I would check whether the manufacturer actually maintains mainline Linux kernel drivers or keeps an up-to-date downstream kernel. I look at their frequency for updates. For media systems having HW acceleration is crucial. Most ARM vendors do a crappy job of providing good open source drivers for this.
Similarly I go and check their Yocto BSPs. If I don't like their organization, that's going to affect my final decision. If it is a power-sensitive project, then the special modes and extra driver support for various sleeping modes come into play.
(Most of the time Intel just wins with those criteria because ARM ecosystem is a mess of proprietary blobs. However there are manufacturers like NXP and MediaTek who do release passable drivers and when power consumption is important they get selected or if the product is very price-sensitvie)
This website looks alright maybe for hobbyists for pure CPU loads with very well cooled systems. I don't find it very useful without the actual engineering details, adding those would massively benefit the website.