The tripod that I use for my primary camera to get those steady images and pan shots is a Manfrotto with a fluid video head. When I want to get a different or handheld look or if I just need to stay mobile I use a Cowboy Studio (I’d would prefer if it was called Eagle Studio) shoulder rig.
I use a lightweight tripod for my smaller cameras. I also use a Joby GorillaPod with grip tight legs and an XShot camera extender in order to get some really interesting camera angles and dynamic shots.