Bronica S- or EC- series with the Type 2 bellows (full view camera movements on the front standard) has everything on your list. You can easily adapt enlarging or other lenses to it as well, since the classic Bronicas had a dual mounting system--Bronica bayonet mount and screw mount, to which you could have an adapter ring made. There is also a reversing ring, so you could adapt reversed lenses to that with step up rings to whatever filter thread your reversed lens has.
Is this the perfect macro setup? For things that need an SLR, where you can view the subject up until the instant of exposure, it probably is. A view camera with a leaf shutter lens, though, will have less vibration.