I agree that there are much better SBC options out there if you just want to run basic Linux applications that require Ethernet or WiFi.
However, where the RPi shines is in how mature the software stack is for it. The support for video, audio, and I/O is truly excellent on the RPi compared to other vendors. Our company had been using RPi3B+ and RPI4 boards to interface with our own Pi hat that passes video through CSI-2 to the RPi and is controlled by the RPi using SPI and GPIO. The I/O stack just works, and it works reliably (not to mention availability of documentation). We ported our platform to the NanoPi M4 and M4B and had nothing but problems. The imaging and I/O software stack is horrid on NanoPi and just plain unreliable. The bottom line is if you want to do real embedded systems things with your SBC, you'll have a much easier time with the RPi than anything else in its class.