Frankly, always thought about Pi Clusters as a nerd indulgence, something to play, not to do serious work.
It reminds me of the Beowulf clusters of the 90s-2000s, that were all the rage at some point, then slowly lost ground... I remember many friends tinkering with some variant of those, we had one in Uni, and there were even some linux distros dedicated to the concept.