I am very happy with the results produced thus far with the SD780IS. The HD video is excellant, however it should be known that once recording you can only zoom digitally. Low light cabilities and sound in video mode are excellent. The stills I have taken look great. Also, to the budget-minded who are upgrading from older digital point-and-shoots, a class 4 minimum 4GB or 8GB SDHC card would be well suited due to the demanding memory of the 12.1 million pixels, and HD video. Also, most old card readers will not process the the SDHC cards so you may have to purchase a new card reader as well.
I have to mention it again...the small size of the Canon SD780IS is mind-blowing...and the functionality actually mirrors its beauty.