I have Studio DV which I got with a DV camera I bought, although it’s a mainstream product. It is very good but my version is old so the newer one is probably much better. My version has some limitations about what it recognizes as an importable video format. It captures DV video as AVI files so seems to prefer that format, but can output multiple formats. The transitions are very good, and has a good title editor. You can create opaque or transparent titles. The only thing I miss is a scrolling credits style for titles. It has great editing features, very easy to select individual frames and move one frame at a time, can view individual scenes or preview the entire video.
I have also used Window Movie Maker once with decent results. I captured a movie from my TV card, edited out the commercials, and burned it to DVD. The resulting DVD had too many compression artifacts, though. You know how a bad JPG photo looks? That’s how the movie came out. I have not had this problem with either of the other two products.
I also use Nero, which has very good features. The title editor is rather limited, and you can’t insert a title in-line with the video. It’s in a separate layer, so you have to put several blank seconds into your video to make space for a title. I have also had problems that the timing of my project is not accurate in the rendered video. Scenes often cut in or out too soon, by a matter of a second or so, which is a long time. There is also no preview feature where you can watch the entire video in the editor, you can only watch a particular section of it that you’ve pasted in. For example, if you import a scene from one video file and another scene from another file, and add a transition, you can’t watch both scenes with their transition from beginning to end. This is really horrible if you’re making a serious effort.