I have and have used rotating tripod collars, L brackets, and macro rails. Each has its purpose, and there is some overlap in their utility. For me when doing close 1:1 macro work, I like to have a tripod, macro rails and a tripod collar. That gives me essential unlimited degree of freedom to move and orient the lens. The downside (and I think its a big one when shooting insects) is that all that stuff takes time to set up, and can be a pita when trying to capture small fast moving spiders and insects.
Re: 180mm macros. I haven't used one, but have put extension tubes on my 70-200mm L zoom lens. I know, not the same as a true macro. From this limited experience, I don't think a 180mm is right for what I do, especially when shooting inside. I simply don't have enough wiggle room to move around and back with that focal length in my indoor "studio", aka my small basement. I haven't given the 70-200mm with extension tube much time outside in the field. So, maybe, it's worth fooling around with (if it ever stops raining).
Again, thanks to all and your informative replies. I appreciate your help.
Best,
Bob