A 'macro' lens is optimized for a short subject-to-lens distance. This is true for large format as well, although you don't very commonly see macro LF lenses for (I think) a couple of reasons:
1: The large image area size makes resolution requirements a little less stringent as you generally enlarge less.
2: As
@thinkbrown says, any lens can be a macro lens as long as there's enough bellows draw.
3: For macro, magnification is key and starting with a very large film or sensor area is kind of antithetic. So for macro work, the question is whether an LF camera makes all that much sense to begin with.
Having said that, there certainly are lenses optimized for close-focus work for larger film/sensor areas.
And no, personally I don't use LF macro lenses. I don't do much macro anyway, and if I do, I start with the smallest sensor/film size possible because it makes everything so much easier (see point 3 above). I've done close-up work on 4x5 and also 8x10, but not very often true macro (1:1 reproduction) and virtually never beyond 1:1 magnification. For what I've done, regular LF lenses have always been perfectly adequate.