Here is my own setup, centred around a cine lens of short focal length (an old Canon 6.5 mm, do note its angle of view is not very wide despite the 6.5 mm because its covering formal is small), an intermediate lens to relay the image to the taking camera (here I used 19 mm f/2.8 Macro-Nikkor, but a microscope lens of similar specification would do as well and likely be much cheaper), and the usual bits and pieces of step rings, focusing helicoids, lens mounts and whatnots.
The last incarnation even has a CPU implemented and support for using a ring flash that comes in handy for hand-held close-ups. The rig is able to focus to infinity.
Do not get fooled by having a short lens, the depth of field is not that great once you come close. But the main advantage from my point of view is that by having a very unusual steep perspective, the illusion of a great depth of field prevails.