Of course, most digitals that I've seen have a reasonably functional autofocus
Every one that I've used has been a real pain if you want to focus on something other than what the camera wants you to focus on. I've got lots of nice clear pictures of rocks when I wanted a picture of the person standing behind them.
Though I imagine it would be really incredibly difficult to make a DSL camera take a shot that was deliberately just slightly out of focus.
My DSLR lens has a very easy manual focus override. It even works when the autofocus is turned on. I've never seen a non SLR digitial with a manual focus that was at all convenient.