Thanks for your advice. I've had a think and will probably end up getting the non-L 100mm lens because it fits my needs and budget. I totally get what you mean though about "buy it right, buy it once", so I'm going to ponder it for a bit longer before making a final decision. I'm only really intending to buy it as something fun to play with though, so I guess I'd be better off investing that much money into a portrait lens that I would use more often, rather than a macro...
At the moment, I only have my Canon 18-135mm kit lens, Canon 50mm 1.8 prime and Sigma Art 35mm 1.4. I primarily photograph my children/family and the odd landscape and find the Sigma Art is on my camera 99% of the time. Do you have any suggestions for a "must have" lens? I find the 35mm isn't wide enough on my crop sensor, but worry that going wider might not be so good for portraits. Again, I need a lens that will work on full frame when I next upgrade my body.