I have been using the Casio QV 11 for over two years now and it has proved excellent value for money (it cost under £100). I have over 200 photos in albums on my PC but I have never bought a film or paid for developments.
The Good Points: It is light and compact, and comes complete with a carry strap and a fabric case. There is a colour viewfinder which shows exactly what you will be taking. It holds 96 photos and you can delete from the camera to make room for more. You can download your photos to a PC or onto a TV (where you could put them onto a video). You can also print them direct through a special printer, but I haven't tried this. There is also a rotating lens but frankly this is just a gimmick. The photos look great on webpages when they are small.
The Bad Points: There is no flash and although it works in dull conditions the quality suffers. It eats batteries at a fairly quick rate so you always need to have a spare set of 4 AA batteries with you. The software for downloading is slow and not very user friendly. It saves in a cam format which means you need to change each picture into a jpg or similar so that you can work with it in other programs. The picture quality is pretty average - if you attemt to enlarge a photo it quickly becomes grainy. There is no plug inmemory to icrease your capacity when away from your PC.
The Verdict: As a handy cheap camera for snaps it is ideal but for photos of any artistic merit it is hopeless. Stick it in your pocket when you go on your hols but don't expect Lord Lichfield to ask for a shot.
How helpful would this review be to a person making a buying decision? Rating guidelines
Unless you are talking at the really top level - Digital cameras, by and large, are for a bit of fun. Quality is patchy and certainly if you really want to get a half decent print from this kind of camera - don't bother. As you say enlarging your photo is pointless, you quickly lose definition. They are OK for basic snaps, but for anything else...leave it to the pros (like me!) Just now I've scanned in on my flatbed a basic 35mm 6" x 4" print that someone gave that wants it converted to jpeg so they can put it on a website. I've scanned it in ast a decent resolution, cropped out some of the blanks space, tightened it up and - PRESTO the pic looks fine and I could print that out to a pretty decent standard onto photo quality paper. What price a digital to do that ? Good sensible op.