As it turns out, I have to cameras capable of shooting HD video. First, my little Sony NEX3. Technically the NEX3 isn't a DSLR, but rather a an ILC (interchangeable-lens compact). It may be small, but it still packs the same sensor as my DSLRs. The Sony is small and light, easy to use and shoots 720p HD video.
The second camera is a DSLR (digital single lens reflex), the Canon 60D. Although I've only had this guys a short time, I've become very impressed with its capabilities. The Digic 4 processor gives me images that are so clean at ISO's I wouldn't have even tried with my old DSLR. It also packs a 3" vari-angle screen, and 1080p HD video. I could go on and on, but you can get much more detail by reading the official reviews on sites like http://www.dpreview.com
During our last trip up to the central coast of California I had a chance to try out video on both cameras. My 1st impressions are that the Sony is easy to use and the quality is very good, good enough for anything I need to do for the short term. The Canon offers higher quality HD video, but is a little more complex. Looks like I'll have some work to do with this one to get it right.
In the meantime, here's a short video I put together using the Sony NEX3, and edited with iMove on little Mac.
More to follow on this as I have time to experiment. Until then, go out and get some (photos and video that is)!