We do a bunch of video editing/CGI professionally. There are different tools that we use for different PC capable jobs. This is my opinion from past experience.
Part1. Broadcast: If using the card as a tuner. ULead or InterVideo. Intervideo uses Titan for menus.
Part 2. S-Video Input: When using the S-Video input (analog) to record, what visually works out for raw files is InterVideo HomeTheater2 which uses the DVR3 in the suite. This is when we transfer non-copyright/private VHS to DVD. The inexpensive, (discontinued now) ASUS 7135 TV card has out performed all other cards. We have tried many Hauppauge, ATI 550/ 650 and the Turtle Beach TBS-1500.
In house we have used ULead, and own, a full Adobe Suite, Nero 7, ATI, WinDVD, and an old copy of MainConceptPVR. The bundled ASUS InterVideo HomeTheater records the best Anti-Aliased 640x480 mpeg frames. It just works. Period. This program is clunky, but easier to skin than a 3DS model.
Part 3. Game Capture: There is FRAPS, FRAPS or FRAPS…lol
Nothing better that we have used capturing from desktop.
Part 4: Production: For insanity we use the Bink SDK to break-down an *.avi into individual frames and edit them with Adobe CS2. We edit with VirtualDub and Adobe Production. We have had the best results compiling for DVD/ISO with Nero v7.8.5.0 when adding soundtracks in AC3 (Dolby 5.1). We have not tried the new CS3 Production Suite from Adobe (the pre-order upgrade is $1400).
Additionally, the AfterDawn forum is a good place to look around.