You could cluster a bunch of Power Mac 8500s if you wanted. There is no processor speed limit to clustering computers.
Pooch is an option. You can also use free command-line options, like lammpi. Apple also has Xgrid, which is going to be built into 10.4.
The bottom line, though, is that right now you should only bother with this if you either a) already have a program that specifically states that it supports one of these networks or b) intend to write cluster programs yourself.
You definitely will not double the speed of your computing experience just by installing something like Pooch onto two machines on a network. In fact, you will see no difference at all. For programs to run on a cluster, they have to be designed around running on a cluster.