I finally bit the bullet and bought this tripod for shooting macro. I first learned about it from Mike Moats, after taking one of his workshops. The tripod almost lays flat, has spiked feet, and has a center column that can be adjusted at a multitude of angles. I like that you can shoot over top of your subject. It also has a loop under the center column when shooting higher, so you can attach a back-pack or whatever for more stability. It is available in aluminum alloy or carbon fibre, and priced accordingly. Really reasonable at B and H, if you live in the States, I got mine at Amazon.ca.
They throw in a carrying case as well.