I believe my DV video camera has both analogue in and out connectors (I haven't tried it though), so I guess that if you have a digital video camera with such capabilities it's possible to transfer your VHS casettes directly to mini-DV tapes. And if you then want to edit and/or compress the video to various other file formats, then simply connect the camera to your computer through firewire.
Otherwise I would go for a Matrox RT.X10 solution (which is a "slimmed" version of the X100):
http://www.matrox.com/video/home.cfm
