This Canon PowerShot SD4500is has been my favorite camera since I got it 2 years ago. It has a really sharp 10X optical zoom. I used it to get the shot of the woodpecker out my window in the previous post.
When I got mine originally, it cost $350. Now you can get it on Amazon for $124. The link is here or go to Amazon and search for "Canon 4500 silver." (Mine is brown but for some reason the silver is less expensive.)
If you're looking for a new point-and-shoot, I highly recommend it.