I have had a Kodak DC210+ for the last 3 years. Just under a megapixel (995,328 pixels) and beautiful color. Unfortunatly printing anything bigger than 5 x 7 is just awful, and it has fixed focus which left most shots slightly soft (esp. distance). It had a zoom, but 35mm equiv. was 29-58mm, so great for wide-angle, but sucked on distance. Also had lousy contrast, pushing EV had limited effect.
I just spent a month evaluating current offerings to replace this camera. I have only one thing to say: Buy a Canon Powershot G1 if you have any dreams of being happy.
Don't sell yourself short. I have taken over 2,000 photos in the last 3 years with my limited digicam, compared to less than 500 film pictures in the previous 3 years. It is just so much fun, the instant gratification is a real plus and the ability to print only the photos you want...
At this stage I would not consider any camera less than 3 megapixels, because you will be disappointed with the resolution. And if you buy a digital you will want to moth-ball your 35mm (My Pentax AE with speedwinder and 28mm lens, 70-120mm zoom has not been used in 3 years!). The 3 megapixel cameras are so good that 8x10 prints are stunning.
It is my opinion that these cameras are finally good enough to replace film. If you choose to buy one with 1.3 or so megapixels, you limit yourself to doing only those purposes you mention, but buying the higher resolution camera will allow you to do everything you would use a 35mm for.
For further study, see these photos. Admittedly he is a pro, but just look at what he can do with the Canon! [url]studio-on-the.net/photography/G1/[/url]
See this site for side-by-side image comparisons from current cameras [url]www.imaging-resource.com/IMCOMP/COMPS01.HTM[/url]
Professional reviews and user forums [url]www.dpreview.com/[/url]
Pricing is steep, I am paying $678 after getting Wolf Camera to do a price-match. But my Kodak cost $540 3 years ago, so not much more for a superior product.
Finally, anyone looking for a deal on Compactflash cards? At Amazon until 6/30 you can buy the Viking 128MB card for $109.99 with free shipping, a $15 instant rebate (enter DEALJUNEWALK in the Gift certificate box on checkout) and you can mail in a $25 rebate. Final price $69.99, a freaking steal!
Madkiwi
(Edited due to the fact that I forgot to mention the pricing info)