I've got a Canon A95 that I've been pretty happy with..
5 megapixel, has a swivel LCD (can face back, up, down, front, etc..)
uses compactflash media, and AA batteries (no dead rechargable packs)