Check out the Sanyo Xacti E6 Camera. It's doesn't get the greatest review from cNet, but for a point and shoot user it's a great camera for a budget. You can find it on eBay or online stores for under $250 shipping included.
After having it for a few weeks, I have to say I'm thoroughly impressed with it. Best digital camera I've ever used (been through 3 or 4 generations of cameras already)!
i would like the following, if possible:
movie with sound
5 megapixels
black and white mode
compact design
rechargeable batteries (would be nice, but not important)
easy to use
IMPORTATNT!!!! USES SD CARD
good optical zoom
decent recovery time
good screen size
and under $250
i don't know if this is possible, as i know very little about camera's. any advice you can offer is quite welcomed.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic