I'm currently looking for a good tripod for (mostly) macro photography and other kind of photography as well. I own a Canon EOS DSLR. Which tripod should I consider?
There are many on sale, but I'm not quite sure which one to buy.
If I were to just go ahead and suggest a specific tripod for macro work it would without a doubt be the Gitzo Explorer. What sets this tripod apart is the 'center column' can tilt a full 90 degrees off axis (and anywhere in between) which was a huge plus back when I was really into macro. You can setup your tripod and (with a counterweight) send your camera about 12" out away from the tripod's center! This is great for when you want to shoot down over something, or there is an obstruction (like a fence or rock) that is preventing you from centering your tripod right in front of your subject and then you can slide it back/forth.
Also, since the center column can tilt a full 90' you can drop the tripod to ground level, putting your camera inches above the ground, many other center column tripods can't go any lower than the length of their center column.
Obviously 'normal tripod considerations' should be observed (desired height, camera weight, price).
This isn't exactly what you asked, but one thing that can be quite useful to go with macro photography if you're going to use a tripod is a slider. I'm not sure what it may really be called, but it goes between the tripod and the camera and allows for lateral movement, usually a few inches. This would typically have a know that you turn to make fine movement, and some other means of locking it.
In macro photography, it is often more convenient to focus by moving the whole camera than to adjust the focus of the lens. Without a slider, you will be futzing with the tripod a lot to get it just the right distance. If you can control the subject by moving it around instead, then you don't need a slider. For example, if you're taking pictures of jewelry, it's easy enough to fix the camera roughly right and then slide whatever the jewelry is on back and forth to get the right composition an focus.
The main criteria specific to macro photography is your ability to get sufficiently close.
How close you need to be depends on the lens and subject. A typical 35mm macro lens for example at 1:1 magnification gives you a working distance of 4cm while a 100mm gives you around 25cm. Check the numbers specific to your lens to find out.
To get this close a tripod with flexible camera placement is best. Manfrotto for example makes several models with a tilting center column. This lets the camera hag from the side of the tripod. See Figure 10 here. This is probably most used for photos of flowers which cannot be displaced. Probaby insects too which you may not want to displace.
The tilting center column creates something not perfectly balanced so make sure to get a strudy one. Another option from Slik is a reversible center column, so that you can attach the camera between the legs pointing downwards. This is less flexible but more stable.
Regardless of which tripod you use, you should get some focusing rails to adjust focus precisely by sliding the camera steadily forwards or backwards. Manfrotto calls this a Micrometric Positioning Plate.
Other brands make this, I am sure, but those are the products I know.
I would recommend getting a tripod with a central tilt column. I believe Benro, Manfrotto, and Gitzo all have one in their product lineups currently.
Then a ball head or geared head. If you can afford it go with geared.
Now the final piece is a precision focusing tool. This can depend on if you're shooting in a studio or out in the field and what you want to invest in.
Sort of standard macro focusing rails look like this. Some are one directional (forward/backward) while some provide lateral fine tuning as well.
Another cool option especially if you're working primarily in the field is this one by Benro. It doesn't have as much range but its a lot more compact.
However, if you're in a studio and some even do this in field is a Bellows which generally comes on a rail:
It's also worth noting since the question didn't specify that if you're trying to do studio work at greater than 1x you may not even want to be using a tripod. The rigs need a lot of stability due to the weight and precision involved so what you'll find some that get into macro do is mount the heads and bellows onto a hard surface that provides stable support and dampening.
The website Photomacrography.net is a great source to get started on Macro photography.
Buying a tripod is really confusing, there are so many at such a variety of prices. Most pros giving advice say to pay a lot for the tripod, as they last forever, and you will quickly decide that a cheap one is not good enough. They call it a rookie tax, you buy a cheap one, decide you hate it, buy a more expensive one, grow to hate it, and finally spend far more that you imaging, say $500 to $1000 and get one you actually love and use for 20+ years.
I listened and I've paid the rookie tax, but I'm just an amateur, so I bought a pretty good one from B+H for about $150. So far, I like it a lot, far better than the $50 one I first tried.
I think @Shazam's Gitzo is a great suggestion. It can be awkward to work a normal tripod into position when your working distance to the subject is so close.
For many subjects I've found a GorillaPod to be really handy. They're not ideal if you have a heavy macro lens like the Sigma 180mm or the Nikon 105mm VR, but they're good for tabletop use, or for getting a bug's eye view of the daisies in the garden. They can be fussy to get stable and in the right position, but they certainly get you close to your subject.
Not really what I think you're after, but handy to have in the bag.