Nero always does a nice job but its slower than some of the others. If you need to convert it first then winavi is very fast and does most formats but I find Nero has better quality
DVDflicks It's as simple as it gets. You drag video (virtually any format) into it, and burn. You can select menus and whatnot as well. Create title pages, whatever you want to do really. Oh, and it's free.
OneClickDvDCopy Pro. I know it sounds and looks corny but its never failed. Also get DVD 43 to decrypt the encryption media companies put on their discs. Burning a DVD takes 5 clicks really..but that includes opening the copy program/decryption software
MagicISO is the way to go. It's free and simple, and also lets you rip discs as well as mount ISO files on virtual drives. Avoid Nero like a Hungarian hooker. It slows your computer to unbelievable levels and fucks with your files so bad it isn't even funny. Crashes often and freezes your computer.