I realize I might have sounded a little snippy in my last message, and for that I apologize.
And I have moved this topic, because it's getting a bit technical.
For those of you wondering what's the difference between clockwise and counter-clockwise water pumps, here's a picture:

The one on the top is a standard Fiero V6 water pump, which turns clockwise, as seen from the pulley side.
The one on the bottom is the one removed from the car I am working on. As you can see, the water passages are completely different. Also, the top pump has a more efficient fully enclosed impeller.
It's now wonder the car overheated!
I'm going to have to replace both the pump and the pump mount/timing cover.