I probably use all the modes except auto, I'll will use the program (sort of auto) but I'll also use av tv and manual if I need to. It all depends what I'm shooting.
Actually auto doesn't do a bad job, I lent a friend a camera set to auto as she was shooting indoors and out and hasn't a clue about cameras, she came back with a half decent set of pics exposure wise.