Yes, there are many camcorders both standard and HD that will transfer video via USB 2.0.
The only thing that you can't do without a firewire connection on the new MB is stream HD video. USB 2.0 can't keep up and usually it bogs down the CPU as the USB standard relies heavily on the processor.
Also transfer times will usually be longer to move HD video via USB compared to FW.
Standard Video camcorders will work fine as will most consumer HD camcorders.
Thanks for this - looks like a new MacBook for me tomorrow!
Store on Boylston St (Boston) checking out the new machines at lunchtime. They are sweet. I like the bigger trackpad a lot, although clicking and dragging on the pad would take some time to get used to I think. I found myself subconsciously looking for the button to click.