I think DVD2SVCD (
http://dvd2svcd.doom9.net) can give excellent results, providing you can find a copy of CCE to use with it. It's not difficult to use, but you will have to read the guide before starting or you'll have problems. I do strongly agree with Lusifer that the simpler to use the conversion program is, the less likely you are to get good results from it, but for most people DVD2SVCD does give excellent results. When I used to be into SVCD I used it quite a bit and it's terrific for low motion DVDs. I have a SVCD I made of an episode of Star Trek and it looks as good as my original DVD. CCE does tend to have problems with fast motion scenes at low bit rates, such as for SVCD, and TMPGenc might be a better solution in those cases as it has some filters that can reduce blocks.
One bit of warning on using CCE with DVD2SVCD. CCE used to lock up when I used DVD2SVCD until I read where a guy suggested running it at Real Time priority under Windows. I would start DVD2SVCD and quickly start the Task Manager and change the priority of CCE to Real Time. Of course, I have a 1 GH CPU, so if you have something newer and more powerful you may not have this problem. Using TMPGenc with DVD2SVCD will not lock your PC, although TMPGenc is a memory hog and I would recommend at least 512 MB of memory for best results.