Mac or PC? iMovie is dang easy to use. A Canopus ADVC-110 or ADVC-55 unit would be about $200+. That's what I did, except I have an Edirol VMC-1 (discontinued) which has video controls and cost much more. But honestly, I hardly used them. You've got to have your TV properly calibrated for it to be of use. It would be good for video tapes that are really messed up. Maybe the frame sync thing is useful though.
iMovie is really simple to use. If a video-ignorant dork like me can get it to work anyone can. Just bank on having loads 'o hard drive space! What's that, you think you have enough? No, no you don't. With video editing there's never enough drive space! Heh! It's just a matter of plugging in your VCR to the ADC, firewire to the PC play the tape and away you go. Then save early save often like your life depends on it because iMovie loves to crash. It loves to crash, but it doesn't hose your work entirely. it's still there, you only lose what edits you were to foolish to not save. Command-S Command-S Command-S!!!