i could write you a book on this subject -
In terms of "quality camera", literally any 3CCD (3-chip) Mini DV camera will do the job based on your requirements.
This means that you can go to Best Buy/ Circuit City and grab a camera from the selection
and get busy and have quality footage.
Our first ummm(thinking) 60 episodes of our Rock TV show were shot with a camera you wouldn't expect a 'professional crew' to use ----> the difference is our Technical Director
is a top-notch cameraman so we can get by w/ that.
A lot of professional cameramen use the big-boy cams at work but for personal usage, operate a small camera for concerts/personal filming and all that.
Where cameras start to break into "prosumer" and "professional" are in the area of audio.
The mid-range prosumers will offer XLR mic inputs and allow you to manage separate audio levels.
The higher end cameras will offer film speed, various settings, additional lense capability etc. At this stage of the game,
you lack the knowledge to take advantage of that stuff so sticking with something mid-range/entry level would benefit you best.
The HD Debate
You DO NOT need an HD camera to film quality footage. Keep in mind, if you film in HD, you also have to utilize editing software capable of editing HD which is additional money to consider.
Personally, I'm an early adoptor of HD and have well over 100 hours of HD concert and exclusive footage to date, UNLESS you are rendering direct to DVD/Blu-Ray you will lose quality via compression if you try to upload video to YouTube, or where-ever.
My recommendation is to HOLD OFF on HD cameras because the industry is still working out the kinks, there will be better hard-drive HD cams coming down the line.
Tips for best results:
When filming - control the lighting and audio as much as possible. It's almost better NOT to film in a loud nightclub than putting something of horrible quality to try to "capture the moment".
Shoot w/ a tripod WHENEVER possible. A quality shot often depends on steadiness among other factors.
Practice zooming in and out (get warmed up) before filming - Your camera lens is the "eye" with which the viewer will see the footage - keep that in mind.
Hope this helps - I'm gonna be doing a bunch of workshops for all these "DVD magazine/ Online TV guys" that have popped up in the past few years so believe me, what I typed out is 100% facts. Good luck.