Bullitt,
I dont have a trans cooler on the vette, but, i do on my 1998 CHevy Cargo Van for Work. I used B and M's plate cooler and got it thru JC Whitney. I got the biggest one they offer - 11x11x1.5 " thick. It mounts to the front of the radiator with the plastic strap kit . It is a very efficient cooler and really drops the auto trans fluid temperature.
If you are talking about a cooler for the 4 speed Gear Box, then of course you will need a 12 vdc pump suitable for oil at high temps. I read in a magazine a few months ago, that, GM now offers a kit for C5 manual transmissions which includes the cooler/pump/ and hoses. I thought about doing this at one time, but i dont race my vette and am easy on the gearbox,so, i just use synthetic 75w90 fluid and change it every year.
If you want to buy a pump seperately , i can give you the name of the company where you can buy it from. Runs about $250 if i remember correctly , but it is ideally suited for hot temp. oil .
Dave