As with any professional equipment, from musical instruments to microscopes, poor technique will produce bad results, even if you are using the most expensive camcorder.
Good technique can produce acceptable - sometimes even great - images on even the most inexpensive consumer cameras.