As others have said, there is way too much missing for an educated answer. Personally I love an automatic trans and have no desire for a manual. With the right gearing, a well built auto and correct converter they can't be beat - on the street or drag strip.
I run a TCI Street Fighter (10" 3,000 stall) and love it. It does not act all like Rcode427 describes below. It's almost unnoticable until you punch the throttle. Then it flashes to 3,000 RPM or so and the tires are blazing. I cannot rev it up in gear when stopped like it's got a clutch depressed until it reaches some magic number.
Suggesting any converter stall with this little info is just wrong.
I drive my car a lot and mostly in stop 'n go situations and having the option of leaving it in drive and just cruise along is great. If I'm feeling frisky (which is most of the time) I can manually shift it with my valve body mods.
The correct combination of engine build, trans and gearing goes a long way in performance. I once had a 2,200 stall and it did nothing. Once I swapped in the new TCI it was like night and day. Everything has to be compatible and mine wasn't at the time.
Whomever you decide to go with make sure you provide them with as much info on the car and your intensions as you can. The wrong one will be a pure waste of money while the right one will put a smile on your face.