Ryzen 7000 CPUs are not the best only when the performance of the CPU is less important than having a lot of PCIe lanes and/or memory concentrated in a single box, instead of being distributed in multiple boxes (for the latter case multiple Ryzen 7000 boxes are cheaper than a single big server with the same total amount of memory and total count of PCIe lanes).
For a lot of memory and PCIe lanes in a single box, there are some Sapphire Rapids models with few cores that are quite cheap, but of course the Intel marketing has decided to cripple them by limiting their memory speed to DDR5-4400. The ubiquitous crippling of the cheap Intel SKUs is intended to force their customers to buy the SKUs with outrageous prices, but all that this has ever done to me was to force me to buy from their competition.
For the same purpose, AMD Siena CPUs are expected to be competitive, but only if they will become available at retail, which is uncertain.