Looking for a new Digital Camera

My HP R967 camera has bit the dust. Died. Given up. Failed to Function.

Whatever description you choose, it is no longer usable. The battery latch mechanism is no longer functional, and it just doesn't work.

This is the third HP camera which I have bought, but which broke for one reason or another.

My first HP (R767) was made unusable by my carrying it in my hip pocket on an extremely hot day. The display screen was electronically (though not physically ... I think) shattered. The viewfinder still works, but I can't see the image I'm recording. Well, it was unable to capture high-density photos .... every picture I took came out a little grainy, and the color was distorted toward the blue end of the spectrum.

The second HP (R867) was drenched when a bottle of water was dumped in the camera bag ... in which the camera was being carried ... during the 2007 Croc Match. After I dried it out, I discovered that videos are all captured in a 'reverse color' format.

This third HP (R967) will no longer hold the battery in place. I can't do a thing with it, it's totally dysfunctional. Too bad; it had some features which I liked (including the ability to zoom while recording videos).

I've wasted a lot of time searching for a replacement compact digital camera on the Internet, and in desperation I'm asking my readers if they can recommend a replacement. It's no good looking for a new camera from Hewlett-Packard. Apparently, HP no longer makes or sells digital cameras of any description.

Here's a list of the features I'm looking for:t

• Must not only take still pictures (preferably 10-12 MP density), but also be capable of recording video (motion) with sound.
• Must record videos in MP3 or similar format; I don't want QuickTime videos.
• Price Range: under $400.
• Must be able to zoom while recording Video .
• LCD (or similar) display should be over 2"; would prefer to also have a view-finder but this is not a deal-breaker.
• Still photo options must include delay, should include burst, and should include date/timestamping.
• I don't care much about "face recognition technology", but it should be able to shoot into the sun without color distortion.
• Should have a 'sports' or other stop-motion "high-speed capability to take still photos without blurring the image.
  
• Highly prefer SD-chip memory capability; I have several of them and replacement, while becoming increasingly inexpensive, would be inconvenient. I already have a battery recharger which is designed for this kind of flat battery. (I would include photos if I had a working camera.)
  
• Highly prefer "HP R07" rechargeable battery type, because I have several and spare batteries are expensive.
• Zoom lens is, of course, a 'given'.
  

Bottom line: I want a compact digital camera with both still and video (with sound) capabilities that I can afford and will give me some unique options when filming videos.

In other words, I want my old camera, but I can't find one. If you own, or know of a camera which fits all of these criteria, I hope you will let me know.
_____________________________________

UPDATE:
I finally found one on AMAZON - another used HP R967 for under $200. I bought it.

But I'm still disenchanted with HP Digital Cameras. I've gone through too many to be phlegmatic about their durability, and I would rather have something that is a but more robust. This new/used R967 is only a stopgap.

The request still stands: if you are aware of a compact digital camera with the capabilities I've described, please let me know.

I really want a good camera for taking pictures of USPSA matches.
____________________________________