Are you making data DVDs or ones that allow you to view on a standalone unit? If the latter, does that TV card only capture avi's from video? You'll need to convert them to mpeg-2 for DVD writing. Also make sure that a DVD player can play the discs. Most new ones will, but my old Toshiba won't even look at DVD-R media.
The avi to mpg2 conversion will eat into your cpu and could take hours to complete. I got myself the Hauppauge PVR-250 video capture card which encodes to mpeg real time - without using system resources as it has a hardware encoder. Raw avi will use huge amounts of space and the video could have sync problems if the pc can't keep up.
I have the new sony drive and its excellent - especially when burning at 4x! I highly recommend it, but make sure you get the latest firmware to allow 4x burning. It will do all discs on the market, but like I said before - make sure the player can handle whatever disc format you'll be using. Most new players can play +R and -R media, and are pretty cheap now, so go for one of these. You can test the quality first on a RW disc before using -R/+R.
Remember that working with high quality video will take up space and system resources so do chunks at a time!