I use a Canon 100mm macro. Mounted to an old enlarger through a lens clamp provides a stable platform. With manual focusing, live-view and the 2s self-timer, stability is very good.
Not that most macro lenses have a shorter focal length when focused close. Building a horizontal setup like this should eliminate all stability issues…