For macro work, the key tripod requirement is flexible camera positioning at very close distances. A tripod with a tilting or horizontal center column is especially useful because it lets you place the camera over a subject, get very low to the ground, or work around obstacles without putting the tripod directly in front of the subject.

Stability matters even more with macro, since extending the camera off-center can make the setup unbalanced, so choose a sturdy tripod if you want that kind of column movement.

A focusing rail (sometimes called a slider) is also very helpful for macro. Instead of changing focus with the lens, you can make small fore/aft movements of the whole camera to fine-tune focus, which is often easier and more precise.

How close you need to position the camera depends on your macro lens’s working distance. Shorter focal length macro lenses require you to be much closer to the subject than longer macro lenses, so check your lens specs before choosing.

In short: prioritize stability, low-angle shooting ability, and a tilting/horizontal center column; add a focusing rail if you want easier fine focus adjustments.