If you're looking for a more generally useful and powerful SBC, the space is taken by mini pcs ( Intel Nucs and their clones). AFAICT SBCs are a strange middle between microcontrollers (Arduinos, ESP32s, etc) and computers that seem to come out of the myriad of options from mobile chip sets; more generalizable than microcontrollers, not as extensible as a minipc.
Odroid seems to have the most powerful hardware in the SBC space currently, support varies by project.
> If you're looking for a more generally useful and powerful SBC
I just want the "modern web" to work Okay (YouTube and alike websites feel slowww, I mean not the actual video playback but the page itself) while keepig it being a Raspberry Pi in all the rest of the aspects (except the price - thanks G-d I can afford it cost more).
For example Raspberry Pi comes with community-standard GPIO also usable for extension "hats", uniform format (so a whole chassis market emerged for it), free Mathematica, well-supported Kodi and Lakka packages, numerous alternative distributions treating it as a first-class target.
By the way, the latter seemes especially intriguing to me. I imagined (before the supply chain apparently broke) Raspberry Pi becoming a standard hardware platform for all sorts of alternative OSes, potentially letting projects like like Haiku, ReactOS, Serenity etc out of the virtual boxes.
SBCs are becoming more popular because one of the prevailing patterns in designing complex embedded systems is to do the real-time control on a microcontroller running on bare metal or maybe an RTOS, and the GUI/database/web connectivity on an SBC running Linux. It's been happening for at least the last 20 years and becoming more popular because the hardware keeps getting cheaper and cheaper.
If your system cost can absorb it, this gives you a huge amount of flexibility and capability.
Odroid seems to have the most powerful hardware in the SBC space currently, support varies by project.