Hello, WD4!
Part of your work is already done, you've processed your old cam-corder tapes and super-8 film onto DVD, As HDEdit says, simply import the clips into PD14(load the disc into your DVD-drive) and in PD14 go to Capture and select the icon resembling a DVD with camera(Capture from external or optical device), then just click "record", your content will be "ripped" from the disc into your media library ready for you to, as HDEdit puts it, let the fun begin!
Okay, now we have the content, what do we do with it? Dropping the content onto the timeline, click "Fix/Enhance" this will let you "touch up brightness, contrast, colour saturation, etcetera, but not too much. There's also "Video Denoise" which, applied moderately, really helps to clean up the on-screen image. Once that's all done, how about bringing the picture out to match wide-screen 16:9 aspect ratio? Right-clicking on the video while it's on the timeline, scroll down to "set clip attributes", and from there select "set aspect ratio".
A window will appear with the choice of "Aspect Ratio is 4:3", "Aspect Ratio is 16:9", "Neither 4:3 or 16:9", choosing the first option will then ask: "stretch clip to 16:9" or "use CLPV to stretch clip to 16:9..." The latter will give you a better result and will adapt your 4:3 material to 16:9 without making people in your clips look like they've been "raiding the refridgerator"!(in other words, it retains, as near as possible, original proportions while stretching the image to fill a 16:9 screen). So there you have it! Some experimentation will be necessary in the colour/contrast/brightness adjustments, but mostly a little "tweaking" will suffice.
Cheers!
Neil.