Many of the newer camcorders can produce still shots on digital memory cards. I have a two year old Sony that can produce 1 megapixel shots. The photos are OK, but nothing to write home about.
You might post a question on the Camcorders Forum if you wnat to find a camcorder that produces a higher megapixel photo.
Capturing a frame from a video with software will produce a photo that is about 640X480. It will look pretty good as long as you do not try to display it on a 800X600 (or larger) screen.
Here is a link to the Camcorders Forum:
http://reviews.cnet.com/5204-7594-0.html?forumID=59&start=0
...
..
.
I have seen the new camcorders that are also stillframe digicams. What about the quality of image capture from digital camcorders without this dual function? I suppose newer high def camcorders would be even better for this.
I have video editing software from pinnacle that will do a frame capture after loading in my pc, but my camcorder is about 10 years old. Most pictures I would be interested in would not be enalargements.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic