A friend of mine bought a Promaster SystemPro 1N ($139.00 or so), and a Promaster SystemPro 3-way head ($49.00) for a total of $189.00. He really likes it. I have been using an old Velbon video camera tripod for years, but just lost the wing nut that tightens the head on the tripod
I am thinking of the Promaster above. The best tripods can be quite expensive, and this one is not too bad, although a little heavy.
I was looking at the Promaster at the local shop and it seems very nice and sturdy yet the one they had was some what heavy if you consider 5lbs. heavy without the head. I don't mind but I'm sure in time I might.
Also to the OP, while looking check out the leg size (diameter) as some seem to very with price. As above, the Promaster seemed to have very thick legs and was very stable compaired to another unit which seemed to have thin and "shaky" legs. I wish more units were displayed at some shops such as CF, compared to aluminum and so on.
I can only say I am purchasing a Bogen/Manfrotto unit, with a nice head and I would hope it will be my last for a long time to come. I believe that the 190"XXX" series support about 11lbs. which if you look around at your gear (I'll just example here) a D300 is around 3lbs. by itself and say a 80-400mm lens is around 3.5-4lbs. plus add in an extra battery adapter @ 1-2lbs and there is a ballpark. I also guess add the weight of the head, 2-3lbs.?
Good luck and enjoy your choice.