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!