I drive mine in manual mostly - must sound weird to anyone with a proper manual car!
Reasons being - I prefer to use engine braking in slowing speed traffic than continually jabbing on the brakes (like most seem to!).
I also like selecting the change points going through the gears for myself - DSG is the best auto I've ever driven, but in auto is does try to get into the highest gear asap, which isn't always what I want. I appreciate the lightening quick changes at all times, but they are even better when I want them in manual mode!
Still, I usually nudge it back to auto in stop-start traffic, which is a real benefit of the gearbox. Takes a lot of leg stress out of the rush hour traffic...
Don't like sport mode, so Manual is best for me. I like to put it in 'N' if stopped for a little while, and the car idles a bit better in 'N', rather than in 'D' being held on the brakes.