Taking the last bit first, I am sorry but I can't suggest anything by way of a tutorial apart from doing a Google search. I have simply learned the 'hard' way, though in fact, when I bought my HV20 Canon HDV camera, all the processes were by and large the same as for SD video. It just took getting used to the different frame sizes and data rates...
Also sorry to have sounded as though I was raining on your computer parade. I was not intending to. As I also admitted, I don't know much about the AMD series of processors, but I still think the X2 you have is similar to the older Dual Core Intels, and not the more recent Core 2 Duos which have a different architecture, of course, and are faster and/or more efficient in their processing of data. And that really is what matters when talking about AVCHD. Hopefully someone who is more familiar with the AMD processor range, AND with AVCHD will be able to offer a better comment.
I was also not intending to appear to express a personal preference, though obviously I chose the HDV route. AVCHD was definitely around as I only bought my HV20 in March this year. And so I had already seen the hassles people were going through with AVCHD to make up my own mind on the matter. I thought that at the very least the editing technology, not to mention the HD technology, was rather more settled for HDV so that is why I opted for that -- even though I have a Core 2 Quad (and had that too at the time I bought the camera) which can handle AVCHD more or less OK (but still not particularly smoothly when editing...! Playback is fine, though).
As for SD vs HD quality on DVDs, if you think about it, an SD DVD has to comply with international DVD standards AND what a stand-alone DVD player is able to play. The international DVD standard says that you can only have a MAXIMUM combined audio/video data rate of 10,000 kbps. A lot of stand-alone DVD players, however, have difficulty playing a DVD with a video bitrate of much more than 8000 kbps which is why there is a general recommendation for home video to keep more or less to that as a maximum bitrate.
But with HDV, you get not only a larger frame (1440 x 1080 compared to the SD 720 x 576 or 480 for PAL/NTSC) but the data rate for HDV is 25,000 kbps. So there is verrry much higher quality all round. AVCHD has an even larger frame size (1920 x 1080, though it can also be in 1440 x 1080) and for most cameras a maximum bitrate of 18,000 -- though more recently Canon have brought out a camera you might be interested in -- the HF11 -- which has a maximum bitrate of 24,000 kbps, and presents its own difficulties, since so far there are few if any video editing programs, including VS, which seem to be able to handle that bitrate when it comes to AVCHD.
Anyway, to repeat, if you downconvert from high def to standard def, regardless of whether you start with HDV or AVCHD, you have to stick to international DVD standards, and that will be in effect, for maximum quality, a bitrate of around 8000 -- just as it would be if you were using SD video from your SD camera. Now you might have a marginally sharper looking image when you downconvert from HD. But you also have the shimmer I mentioned which is for me a bit of a bummer. So if I personally intended to keep on making standard definition DVDs, I would keep on using my Canon mv930i SD camera which still gives me excellent quality video at 8000 kbps, plus I *don't* get the shimmer...
As for Blu-Ray, no you need a special Blu-Ray burner AND player AND the still ultra expensive discs to be able to use that format. The only alternative is in fact to start off with either HDV or AVCHD, do your edits, then burn your high def in that same format to what is called an AVCHD hybrid disc i.e. using AVCHD format, burned to a quasi Blu-Ray file structure but on an SD DVD. It plays back in magnificent high def BUT (and there's always a 'but'...) while you can burn such a disc with a standard DVD burner, you can only play it back on a Blu-Ray rated player and moreover one which is also rated to play hybrid discs!!

The Sony PlayStation 3 is one such player and it does a wonderful job...
One downside of hybrid discs is that if you use the top quality AVCHD settings, you can only fit around 20 minutes of video on a standard DVD. But for me that is no problem since I buy my DVD blanks for around 25 cents each, whereas if I had gone to the expense of buying a Blu-Ray burner, the minimum price I can get Blu-Ray blank discs here in Australia is $25 EACH!!!