The i860 was lovely! I wrote some software for an i860-based hypercube back in the day, and it was the fastest thing on earth.

The reason it never went mainstream is easy enough to explain: expensive chips and (for the hypercube) a very different programming model.