I usually drive in manual mode (M) with DTC off once (not fully off), and not using sport. Sport for me is only when another sporty expensive-ish looking car is sitting next to me at a light :P
I had the car stall on me twice when coming to a stop when in D mode early on when I was getting used to how it behaves. Since then the first I do when I get it in the car is flip it to manual and turn off the dct once, and when coming to a stop always downshift it into first. Once you get used to the scenarios the car misbehaves in you can learn avoid them... Not that I am defending bmw in any way - they really should adress these issues.