This subject has been beat to death many times. The torque convertor in the automatic helps give more "go" for towing, while taking it easy on the rest of the drivetrain.

Read this thread on NOR where I detail my towing experiences with my boat and my Frontier 4wd 5-speed:

http://www.nissanoffroad.net/messageboard/topic.asp?TOPIC_ID=16656