For example, spi is an easy hack to bit sample a digital level and stream the results into memory for later processing. You can effortless do this at 20MHz+ plus on an rpi4. When you want to stream multiple digital levels simultaneously (in sync), DMA on gpio is a nice generalisation. (Could perhaps abuse I2S inputs too, which might be present on a more generic x86 board?)
I always wonder about a nice PCIe board supporting good DMAable gpio/spi/i2c/etc on standard x86 machines. I'd probably pay a fair amount of money for a quality one. But it's a product I've never seen on the market. Bodging a USB gpio interfaces with one of the relatively low spec chipsets seem like a pale, inefficient and high-latency imitation.
Actually, given the RP1, maybe the rpi5 has slow/non-DMA gpio too? I haven't been able to check it out yet as these boards still don't have mainlined linux support and I'm not up for buying toys that don't. (Am I imagining it, or did they used to be a lot better at mainlining support for their boards promptly?)
Peak power from the Raspberry Pi 5 is 12W, according to Raspberry Pi themselves: https://www.raspberrypi.com/news/introducing-raspberry-pi-5/
The N100 SBCs have a much higher peak power and heat, but it's also fine to let them throttle down.
Really though, I think most hobbyists would be perfectly fine with a base model 2GB RAM Raspberry Pi and a cheap USB to NVME enclosure. It's not optimal, but it works and you're not spending money to hot-rod something that will never be all that fast anyway.
Very different than, say, Germany. Power efficiency becomes a much lower priority.
The things that need an rpi and therefore must use power from the wall anyway, I always find myself thinking would be better done by a minipc, eg one using a laptop cpu like a 7730U.
Costs more, but you get like 3-4x the speed at a similar power use, and have much more flexibility on what OS you can use because it's a "proper" PC.
Don't get me wrong, I like the idea of rPi. I have a Pi Zero that I've used exactly once because I wanted to do something and I came across a project that did exactly what I needed that used rPi.
I just find there's always a better option than rPi for every project I find myself doing.