I'm a manual guy and have DD'd manual vehicles and grew up on the farm with manual trans tractors, grain trucks, pickups, etc.
I love rowing gears, I also like having to know and/or preselect the gear you want to be in for any WOT type driving. I have never enjoyed autos, but the wife's ML350 Bluetec is of course an auto and I don't mind it. My 650hp Silverado SS is my DD when not on shift and I wish I could convert it to a 6M!
I have also had the pleasure of riding in and driving a brand new C7 Z06 A8. That auto shifts incredibly fast and firm, but again, it has always bothered me not knowing what gear it will select when you punch it and it downshifts. Of course the nannies in the new Vettes are world class and that car puts all 650hp down extremely well. Even so, if I was buying a C7, it would be manual all the way.
Also drove a DCT M3 V8. Paddle shifting was fun, and it held the gear like a manual which definitely made the driving experience feel a lot more "in control." If I couldn't buy a proper manual, a DCT would be my next choice.
Currently, my 1999 Camaro SS is an M6, my Grand Sport is an M4, and my quad is a manual. Lawn tractor is hydrostatic LOL!