For example, on the CPU one may pin all cores to stream a USB camera or software decode h264. With the SoC GPU decoding or streaming with the v4l2 interface might take up 30% on one core (mainly to handle the network traffic.)
The Raspberry Pi are not the fastest or "best" option (most focus on h264 or MJPEG hardware codecs), but the software/kernel ecosystem provides real value. Also, the foundation doesn't EOL their hardware often, or abandon software support after a single OS release.
A cheap RISC-V SBC is great, but ISA versions are generally so fractured (copied the worst ideas of ARM6)... few OS will likely waste resources targeting a platform that will have 5 variants a year, and proprietary drivers.
A Standard doesn't even need to be good, but must be consistent to succeed. =3
This results in a higher performance per Watt, but doesn't scale well to higher-power applications.