To a certain degree, yes, your 8mm film to DVD transfer can look as good as your film. Most people are unaware that positive 8mm film (the film type you got back from Kodak when you sent it in for processing) was never intended for transfer to video. It was only intended for viewing on a projector. Negative 8mm film was intended for transfer to video. When negative 8mm film is transferred, it is possible to capture all the highlights and lowlights in the video. However, when positive film is transferred to video, you cannot reproduce the same degree of lowlights and highlights that are present on the film.
There are a few things you can do to get the best 8mm film to DVD transfer possible. The first is to scan the film at 1080 lines (HD video resolution). The 8mm film has around 800 to 1000 lines and scanning the film at 1080 lines will at least get all the details from the film. Second, make sure that the 8mm film transfer process includes color and exposure restoration. As the old movie 8mm film sits on your shelf, the color shift (usually toward blue) and the exposure gets darker.
Scanning your film at HD resolution and using a film restoration machine is the best way to get a 8mm film to DVD transfer that is as close to the original film as possible.