The combination webcam/camera has just about become extinct, due to their cost, lack of sales and the cheap price for webcams.
You can find plain old webcams for under $20.
But there are a few of those combo cameras around....try here for a sample:
http://www.aiptek.com
Look for the Blue Pen Cam.
It calls itself a 3-in-1 camera.
Still camera, movie camera, webcam.
How good is it.......well.......If you buy one, you can report the results back to this forum.
...
..
.
Hey everybody new here. Basically im lookin for a good webcam that can double as a digital still as well when its not connected to the computer. Does anybody have any suggestions and where to buy? Resolution doesnt have to be great, as most of the webcams im seein now arent any higher than 1.3mp and most are like .5mp Thanks in ahead

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic