The raspberry pi was never meant to be a power house. It’s whole goal was to make support and learning easy. A few, very well maintained models, with the same core chips. The last bit is the cause of the shortage. They can’t easily redesign without fragmenting the support base. That is completely against their ethos.

I’ve also found, once you hit a Pi’s limit, that it’s best to go to something more specialist. My go-to options are NUCs for general computing, or the Nvidia Jetson series, for portable brute power. Anything that saturates a pi will quickly saturate the smaller SBCs soon after, as well. They suffer from many of the same bottlenecks.