I never worked with Connection Machines, but I am also interested in them. If you haven't yet done so (which is unlikely), do take a look at Danny Hillis' PhD thesis:
right now reading this:
http://stochastix.wordpress.com/2008/12/11/the-connection-ma...