I'm thinking of using a Pi as a main stream computer and I'm bumping into comments that the Pi is insufficient.
Since buying a dedicated Linux machine is not an option, would it be relatively easy to piggy back say 4 Rpi's to spread the cpu load and aid the insufficient RAM issue that appears on the forums?
First idea. Ignore the comments. (To the extent that only you
can decide whether an RPi is sufficient for your needs or not.)
Second: " would it be relatively easy to piggy back say 4 Rpi's to spread the cpu load and aid the insufficient RAM issue "
A2: No. It is
relatively easy to network a number of RPi systems together, and the Raspberry Pi Foundation have documented how to do it. It won't result in a single 'better' computer as you hope, and it does nothing about the "insufficient RAM issue". But have you actually encountered this issue? Is it a real problem for you?
Bottom line is: if you are seeking a general-purpose computer system with more processing power and RAM than the current top-of-the-range RPi3B+ then the Raspberry Pi Foundation does not presently have a product that meets your needs.