A SOLID and SUBSTANTIAL tripod is going to run $500 and up. There are some perfetly acceptable systems for less, say between $250 and $300, but there WILL be limitations in either strength, mobility, support, pan/tilt dampening, etc. You'll just have to decide what you are willing to compromise on, knowing that you might one day see your camcorder take a nosedive and lose its lens.
Don't laugh, saw a guy with an ENG rig, popping around with one of those Miller (relatively expensive) composite units like he was nobody's business. Left it alone for a second while he strutted into everyone else's shot and...
...what was that noise? Oops! Job over, no backup, probably blamed it on "some yayhoo nosy eyeballer in the crowd," but WE knew what happened. Too heavy camera, too light rig, even though strong, and tilt.