Manual mode for me but it took me many months to grab the ropes of it as I'm too used to shoot with compacts where Auto mode is a no brainer, and is capable of shooting everything and anything with the camera in full control of ISO, shutter and aperture.
Like Ian & Rashkae mentioned, I believe that more than 50% of the DSLR owners are starting photography as a leisure hobby where full auto mode will satisfy their needs initially. Thereafter, some of them may move on to the next level or further.
I must admit. For quite a while during my initial stage when I didn't understand left from right, I was Auto all the way until one day I looked at my photos and I simply couldn't explain why it all turned out not so nice.
It took me a while before I finally went into P mode, Av mode and M mode with more understanding.
So I am guilty of being an Auto newbie at some stage of my life.
Come to think of it, I think can convert movies into MOV format and copy to the card to view thru the LCD screen. Dunno that works or not. I think for those shoots where you need to wait either for your turn or for the environment, can watch movies thru thr DSLR. Beats carrying another device around. Just need to bring another card. LOL.
Back to the topic, I tend to use Av mode most of the time, I use only manual when I know that I got time to test and play around with settings. Am still a newbie in terms of exposure. But sometimes, I know when I want and what I need so I use M mode.
Really never use CA or Auto anymore. Dun have the reason to, cos Av and Tv is kinda like semi auto.