A note for FitKat: I hope you don't think all you need is the right camera to make professional quality videos.
The camera plays a part, but you also need proper video editing software and a computer powerful enough to run that software.
These are basic components, each requires accessories and add-ons (such as a tripod, as you've mentioned).
That's still only the equipment part. There's a lot of skill involved with filming and editing, and getting that skill takes time and patience.
With a budget of $200 you would be able to get the GoPro Hero3 White Edition which can record 720p at 60fps. To get the tripod mount you will need to add an additional $7.99. However, the White Edition isn't known for it's lowlight performance so when you shoot you need to make sure you have to make sure that what you are shooting is well lit. They do offer a free version of CineForm Studio which will require a powerful enough computer to run it ( http/gopro.com/3d-cineform-studio-system-requirements/). Keep in mind those are the minimum requirements. As Andrew_berge has already mentioned it takes time and patience to become a skilled videographer and editor. Shoot as much as you can for the practice and review the shots to see what you did well and what needs improvement. At the very least you must learn your camera's weaknesses and strengths. Anyone can shoot video but not everyone can shoot good video. Editing matters.