Sorry, but recording DVD's from a PC video input is nearly impossible with a bunch of products due to Macrovision detection. For example, ATI's driver refuses to work and stops recording software if it detects Macrovision.
For doing input tests, I've copied a couple DVD's from my personal collection with macrovision removed.
I have tested a card with Macrovision detection disabled, but that card would cost you over $140. It's the Turtle Beach Video Advantage, and it doesn't have a tuner, just inputs. The majority of its price is based on the included software package, which is better than average.
There are "Macrovision Workarounds" using hardware macrovision removal, but most of these are illegal...the only ones that aren't are designed to serve "other functions" and remove macrovision "unintentionally". These Macrovision removers have been around since the VHS days, as VHS also uses Macrovision.