When I first saw it, I thought of the epoxy putty that's available at basically any auto parts store - it works the same way (and smells truly foul), and works well if you can use enough (but I've certainly had cases where either the mating surfaces were too small or the stresses were such that it couldn't hold)

On a side note - it's kind of obnoxious to have the video start auto playing - I just spent five minutes looking for the source of Billy Mays's annoying voice.

The Sanyo Xacti HD2 has a microphone line in, and I've heard good things about the quality of video - it's 720p like the Powershot TX1. I haven't been able to pull the trigger and buy one myself yet, but it certainly is tempting.

I've just bought the older flip video 1 hr for just about $100, and I couldn't be more thrilled - I think you're right, though, that this will be better when the price has gone down.

The video is way better than it has any right to be for the price, and what I like about it opposed to miniDV is that if I shoot 10 minutes of video it doesn't take 10 minutes to import it, it just takes whatever time is required to transcode it to h.264 (because, unfortunately, the codec it records in is not compatible with imovie).