I've done a bit of research on this, and it seems like all the compact
cameras that allow 640x480 with ulimited recording times a

pentax 43wr
fujifilm F700 (and others like 710)
various sony models, P8, etc
Canon PowerShot S1 IS

There's also the Sanyo Fisher FVD-C1. But the one thing with all
these cameras is that none of them use compact flash. Meaning the
largest media available is a 1 gb sd card or memory stick. It doesn't
seem like the 2 gb sd card is stock anywhere yet. Ah, there is a 2
gb memory stick, but it's really expensive at $300.

So, is there a camera out there that shoots movies in 640x480 with
unlimited recording times that uses compact flash?

Thanks,

Lee