All you need to edit your movies and to create DVD's of them is included with every new Mac sold. The software suite is known as iLife and includes, iTunes, iPhoto, iMovieHD ,iDVD and Garage Band.
Your only problem will be how you will capture the existing video. If you have a digital camcorder, it most likely has a Firewire connection (IEEE1394) or iLink (Sony name for Firewire) or a DV output. That takes care of the DV tapes. You could also use the camcorder as a pass through digital converter. Feed the output from the VCR to the camcorder and out to the Mac via the firewire connection.
If you have something that will play the 8mm tapes, you should be able to do the same with them.
The Mac Mini will do the job but remember, video takes a lot of hard drive space and 80GB may not be enough, although you could always get a large external drive to store your unprocessed video on. Also, the only Mac Mini that comes with a SuperDrive (8x double-layer SuperDrive (DVD+R DL/DVD
I have experience with Win and Linux but not with Mac. I am interested in purchasing a mac for the purpose of transferring my home movies to DVD. I have 8mm tapes, miniDV tapes and VHS tapes. The question(s) at hand are:
Which Mac to purchase? Can I use the mac mini? Or do I need something from the other end of the mac range?
What other hardware do I need? Video capture card?
What software should I use... does it come packaged with the mac?
Ed

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic