One of the reasons I like a small camera is to snap pictures of tasty restaurant meals. I found the Canon S30 was a little underpowered in the flash and ISO areas for taking good closeups indoors in dim light. The 20D obviously is overkill to pull out at a small table in a crowded dining room; besides, it would probably still have the 300mm lens on! Now that we have the Canon S3 and Canon SD700, can we say we've got the solution?
The SD700 actually turns out to be the champ here. Normally, flash burns out the whole picture when it reflects off dining plates. But with the SD700 in manual mode and the flash turned down in strength to -1 EV, it gives a great exposure at low ISO every time.
The S3 has a problem because of its strong flash. I haven't found a consistent flash setting that avoids burnout. Luckily, with its powerful zoom, I can back off a little bit and zoom in. But that takes a bit of experimentation each time.