In general VCD will look horrible compared to anything else - about as bad as a VHS recorded on extra long play or worse. SVCD will give you some better quality at the expense of a larger file.
Basically if you don't care about the quality of the recording, use VCD or SVCD. If you want good quality then move to DVD - DVD writers are only $140 or so now.