Chew Toy, I missed your post earlier..... OK, a long-winded answer here.......
First, in response to AFB's post, actually, Lensbaby lenses are not actually macro lenses. They're closeup lenses, and there is a difference. They're also specialty lenses with appeal to those who want to get certain creative effects in their images which they may or may not be able to get with actual macro lenses if they don't already have well-honed basic knowledge and good technique. The Lensbaby line makes special effects a lot easier and quicker to accomplish. On MR in the Digital Photography section, actually MollyC is the primo Lensbaby enthusiast and expert, not me! I've got one Lensbaby lens that I bought a few months ago just to play around with but it really is not a true macro lens, just a closeup lens with particular attributes. It's fun but I regard it as a novelty, a gimmicky item. Molly is using her collection of several Lensbaby lenses with her Nikon Z6 because she likes to shoot flowers and to create images in a certain style, but also because to date, Nikon has not yet offered a native macro lens to go with its Z mirrorless camera bodies. Nikon users have to use the FTZ adapter with the two f-mount macro lenses that Nikon has made in the past. (That is one big reason when I was ready to shift to mirrorless I said goodbye to Nikon. I wanted native mirrorless genuine macro lenses right from the get-go and Sony offers them, along with other native lenses, many of which Nikon still doesn't offer yet, either. I don't know anything about Canon so can't speak to either their mirrorless or their DSLR available choices of bodies and lenses.).
OK, setting aside my lack of knowledge about the Canon system, I can at least contribute to the discussion by backing up Eric's suggestion of using extension tubes as a good way to get up close and personal with your subject(s) as well as mention the option of a series of filters in various diopters which do the same thing, closing the gap between a lens' usual minimum focusing distance and allowing the user to get in closer to the subject(s). Extension tubes are made to fit the various camera manufacturers' mounts, so it's important to be sure that you get the right set for your gear. An extension tube or set of stacked ones mounts on the camera body and then whichever lenses you want to use mounts on that. A filter or set of filters in various diopters (often called closeup lenses or filters), as the name suggests, needs to be in the appropriate filter size of the lens with which one is planning to use it. If your lens is a 77mm or a 67mm then you need a 77mm or 67mm size set of closeup filters, respectively. There is also a way of working around this by using step-up or step-down rings, but let's just keep things basic here in the beginning.....
So. In order to be more helpful and answer the question you have posed here we would need to know what type of mount the camera you have actually uses, since over the years Canon has changed that a few times. If you want to just buy a macro lens you need to be sure you're getting the right one that will work with the mount on the camera. Also, again the mount becomes important if you are considering extension tubes. If you're keen on the idea of using close-up filters then it is important to know what lenses you already have and the filter sizes they take.
Oh, I'd love to be able to spend a little time with my A7R IV, my beloved 90mm macro and maybe even the 50mm macro and your adorable Butters! We'd have so much fun.....
I'm contacting Sigma today to see what (if anything) could be covered from this event.
However, I am wondering if my credit card insurance will cover some of it, I'll see what the repair bill is going to be and then ask.
