I've driven a mid 12 3500 stalled z28 - It was fast as fuck and fun to drive, but I'd still rather drive a 6speed.
It's all personal choice, I simply find driving a 6speed gives me more enjoyment than an auto.
Now if I was going for pure speed, I'd definitely go the auto path with a good stall - however I'm just out to enjoy myself.