I wouldn't buy an auto car without a tiptronic box. In full auto, you're right - sometimes a car can run away with you, I often notice cars braking unnecessarily on say, downhill sections and areas of a road where I would want to tighten the car up a bit as I run in to something. So the autos I drive, I mostly (like pretty much always) drive in manual sport so that I still have control over my gear selection.
Honda have seen sense to add that manual option to their dct box ... And that's probably the only setting id use ...