I've used a Mamiya C330 since the mid 70s. After lusting over a used C220 body in a store three or so years ago, I received it as a gift for my birthday (aren't wives and friends wonderful?
).
The C220 is a bit lighter and simpler than my C330, but it does make a real difference having available to me the lens and accessories that I've accumulated over the years for my C330 (most are compatible).
The other TLRs mentioned here are smaller, and are lighter, but that may or may not make a lot of difference to you. Rollieflex lenses are wonderful, but subject to some relatively rare other models, you are restricted to a single focal length.
My kit with 65mm and a 135mm lenses is incredibly flexible, incredibly small, and gives great results.
Otherwise, with just a little more camera bag space, my kit with 55mm, 80mm and 135mm lenses also is incredibly flexible, reasonably small, and gives great results.
With a paramender and a decent tripod, really good macro is easy to accomplish.
Maybe most important for the OP, if you start with a good Mamiya TLR body and lens, and you like it, you can expand!.
Matt