i pic the c6, i have been in many offroad adventures and had both type trannys, to straight out pull something its easier on the drivetrain with an auto. if your on a hill and have to use the trk to pull something uphill, the auto will be a lot nicer to the u-joints and axles, the zf can break stuff real quick, and i do know the parking brk trick when taking off, but that only helps so much. also if you have to ford deep water you run a real good chance of soaking your clutch. i burnt a clutch out of my offraoder in 5 minutes due to being stuck in a big mud/water hole and trying to get out of it. had to be towed out and the clutch was burnt that fast. both trannys will have good and bad. i would pefer an auto with the set-up your going with, a very well built c6 with a low stall converter.
also if your parking brk is a little out of adjustment, and your clutch has some wear on it, your trk call roll, no so with an auto, the ground has to move for the auto to let the trk roll