There are constant cries on the forum from new and intermediate videographers for info on whether they need expensive upgrades of equipment to get 'high quality video'. The answers from the advanced members and moderators always stress, 'master the tools you have first then move up'. Many times that answer meets the satisfaction of the member asking the question but sometimes I can tell it's not 100%.
So for you shooters using small consumer grade cameras now feeling 'big camera envy', don't. Cameras are tools and just like a mechanic wouldn't use a screwdriver to fix everything on a car, cameras are similar. In my experience I've used the 'right camera for the time'. Depending on the setting, it was a big 3CCD camera with pro lenses or a small handheld rig with alternate lenses and a lens adapter.
Even if all you have is a small prosumer rig, you're still in good shape to get excellent footage if you a) have a solid grip on your camera's basic functions (exposure, focus, white balance, audio), b) understand the basics of composition (rule of thirds, depth of field), c) shot framing (wide shot, medium shot, etc.) screen direction and the 180 degree rule.
Where you start adding to your video's production values once you have a grip on the basics is adding camera movements like; pan, tilt, dolly, crane, etc. Again, you don't need to spend your life savings to be able to do those things. In fact you may already have the equipment to do all of the things I just mentioned if you have a small tripod and or monopod. Here's a video by Jan Van Der Meer (no not the famous 17th Century painter) as he shows some ridiculously simple techniques for getting advanced looking camera moves using a small monopod and a small tripod.