As long as you have an analog input on the camcorder, it should work. Just record the VHS stuff to digital tape, then download the digital tape to the Mac via Firewire.
Some camcorders (certain Sonys and newer Canons) will convert analog to digital on-the-fly - in other words, you don't have to take the intermediate step of recording to digital tape.