The important thing to note here is modern DSLRs are not really designed for manual focusing. They can support manual focusing more as an afterthought then an actual design decision.
Back in the days of film focusing was hard. So there were all sorts of aids to be able to focus correctly.
Just go to the used dept of your local camera store (if they still have film cameras) and you'll see what I mean. Waist level finders with magnifying glasses to make sure things are in focus, focusing screens you can look through that tell you when an item is in focus (that's the katzeyeoptics page someone posted)
But digital cameras don't have any of that because your digital camera is probably better at focusing in the majority of situations then you are. With top of the line cameras you can maintain focus on a fast moving object in the dark. And with facial recognition and all sorts of other technologies there's no reason for manufacturers to build in good manual focus.
That's why if you take a lot of new DSLRs on manual focus mode, the pictures might look terrible. You'll have difficulty seeing if a shot is sharp on the viewfinder -- and a little bit of blurriness will ruin the shot on screen...
I think part of this is due to the fact that smaller digital sensor size yields more depth of field. So when you look through the view finder with the iris of the lens wide open, you get more depth of field then with a film camera.
I think the best thing is to understand your medium. Digital camera? Stick with autofocus except for unusual situations. Film camera? Play around with focus all you want..
And don't knock film cameras -- they can be a lot of fun. With my mamiya (medium format, with something called a waistlevel viewfinder) there's a magnifier built into the viewfinder. You can see every little bit of the picture -- which parts are out of focus, which are in, and you can see every little detail.