While I agree with the sentiments, not least the expense issue, this is really only for seeing whether you like macro, or for occasional macro work.
I have a tiny confession. (Some bigger ones may emerge in other contexts). I purchased reversing rings, and one or two other items for adapting existing equipment, but have not used them).
Having struggled with manual setting of diaphragms, even with that of my Canon (FD) 20mm bellow lens, I have obtained OM autodiaphragm models and other true macro lenses (Tamron 90mm f2.5, OM 50mm macro). As I deal mainly with active subjects such as insects (some close-ups, rather than true macro) this makes image capture (not least framing the subject) much easier and quicker. I have added dedicated macro flash equipment for freezing motion and giving greater depth of field.
What I am saying is, when you have the commitment, and can afford to, remove some of the frustrations and disappointments by using kit designed for the purpose. Having said that, I am now moving some of my activity into the next phase, of seeing what I can do with lenses designed for specialist purposes but not the ones I want to use them for. I have also somewhat stretched the possibilites of the macro lenses, for example hand-held shots with a 38mm bellows lens on extension rings.