I've been using a Feisol Ct-3401 for several years and been happy with it. It's sort of middle of the road in terms of weight, height, , folded length, cost and features. It'll easily handle a DSLR. Feisol makes a range of models that fit different needs, all of which are highly functional and cost effective.
The Feisol range is worth looking at. I'd make other suggestions, but honestly haven't looked at tripods since.