Wanting a camera that I'd virtually always have on me, I opted for the Motorola Zine Z5, a 5 megapixel camera with a phone built in, considered the best camera phone when I got it ~ a year ago. As long as the lighting is good, photo quality is excellent and blows up well to at least 11 by 14. Call quality is good too
Before that I had good results with the Canon A510.
I've been a fan of Ken Rockwell's site for years, first almost buying the D70 and then the D40 when the D70 disappeared, but never getting either since I knew I'd usually just have something that fits in my pocket with me, and I mostly take photos of things that don't move.
For a DSLR I'd still pick the D40, and if price were no object I'd look at Leica's digital rangefinder, the M9. I visited a friend in Ohio a couple weeks ago and watched him take photos with his $5000+ Nikon D3, but also noted he quickly put the heavy thing down and started snapping shots with his water/shock resistant Olympus compact camera. Some of the most interesting shots were taken with my camera phone, long after everyone else had set down their cameras.