I've autocrossed a third gen Camaro with a 700R4 for several years. I've found that a lighter torque converter will really make a difference. A lighter converter (higher stall speed) will also build more torque for better acceleration out of the tighter corners. Most of the autocrosses I've run were limited to about 60 mph. I put it second and left it alone. In an open tracking setting the only difference I found was down shifting later in the corner, just prior to throttle applicaiton, seemed to work best. Based on what you are trying to do, I think you'll be happy with an automatic.
For what is worth, I wouldn't get a paddle shifter or anything trick like that. Find a B&M rachet shifter you like and you'll be fine.
So, approximately what size stall speed? I'm having a manual valve body TH350 built and would love to be able to autocross a V8 s10 with this tranny.....I was thinking in the 2500-3000 rpm range......