You are using an Apple Macintosh.
What you have not told us is which one.
To get the video from that standard definition, PAL, DVD in the camcorder to something FinalCut can work with, we make ONE assumption: Your Macintosh has a drawer loading DVD drive. If not, get one (I like those from LaCie - there are many others). and get it working with your Mac. Never put a small or odd shaped disc in a slot loader - you will scratch the disc and likely break the drive.
Then...
Download and install HandBrake
http://handbrake.fr/
Finalize the disc in the camcorder (if needed - read the camcorder manual).
Take the disc out of the camcorder and put it in the drawer loading drive associate with the Mac. USB transfer of video will not be recognized using USB.
Launch HandBrake.
Rip the DVD video to a format FinalCut or Premiere can deal with. .dv, .mov, .mp4 are easiest - there are others.
When the ripping is complete, quit HandBrake. Launch the video editor. Drag the ripped video to the Log/Capture or timeline area.
Warning: Video captured by DVD based camcorders was not meant to be edited. Video quality will be poor.
You can also try copying the files form the disc and converting them with StreamClip - though I don't know how well this will work.
Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic