price, good quality and reliable
That starts at about $2,500. Michael gave you the link to my list. And he's right, I get the question "I want my projects to sound like a mega-million Hollywood blockbuster but I only want to spend $3.99" at least three times a week.
Good/great sound is a combination of the proper technique and the proper tools. The first required technique is getting the mic off of the camera and onto a boom-pole. The second "technique" is learning how to be a boom-op.
As far as equipment goes you can cobble together a set-up with consumer items and, as long as you have someone to work the mic on the end of your DIY boom-pole, your sound will be somewhat better than your camera mic.
The Rode VideoMic is a decent consumer mic. Your little camcorder probably doesn't have a mic input, so you will need a sound recorder is addition to a mic. So, although it's more than your budget, go with something like the Alesis PalmTrack, Zoom H1 or Tascam PR-10 as your recorder.
And that is only the first step; the next step - my specialty - is the audio post process; dialog editing, Foley, sound FX and mix, each of which is another art-form unto itself.
Just for fun, this is a photo gallery of professional sound carts and such.
http://gallery.me.com/jwsound#100220&bgcolor=black&view=grid