Really?! Hmm. I have the SD800 IS and it also shoots in AVI but the video's did not appear on the iPad when I synced the photo album from iPhoto. I wonder what Im doing wrong.
I just checked the specs on both and they are both "Movie: AVI (Image: Motion JPEG; Audio: WAVE (Monaural))" so it should work.