I would recommend pretty much any PC tuner card that has video inputs. You can likely find a card like the Hauppauge PVR-150 very cheaply (<$50) as it has been discontinued. This will capture the video as an MPEG-2 file which is probably the most popular type of video file which can be used in almost any video related software and MPEG-2 doesn't have to be re-encoded to be converted to DVD format (VOB files) since they are essentially MPEG-2 files.
You can then use lots of different software to edit, add titles, still photos, background music, etc. and then author to DVD. Adobe Premiere Elements will work as will Windows Movie Maker and I believe similar software comes with Macs. You might need a separate program to do the DVD authoring but I believe you can find free programs to do that.
Personally I think you are far better off capturing to a PC rather than using a DVD recorder, but even if you do capture to a DVD recorder you could then rip the DVD file to your PC's hard drive.
And then you will have a TV tuner card that you can use for other purposes, such as using your PC as a PVR.