First off, welcome to H-A.Net
Well, obviously the more torque the better. However, it can be decieving, just like horsepower. Horsepower is usually the greatest indicator for how fast a car is, and torque is the greatest indicator for how easy it is to drive the car at low RPMs.
http://www.howstuffworks.com/fpte3.htm
Go to that website, and if you have some questions that are more specific please tell me
As far as what's fastest between the Accord V6 automatic, Acura TSX 6 speed, and Acura RSX-S...the TSX should be a bit faster than the Accord but slower than the RSX-S. But this car has much more to offer than the RSX-S, so they really do not compete in any way.
Chris
PS - Are you trying to decide which car to buy?