Since you are on an R10, I am really satisfied with the Canon RF 35mm f/1.8 IS Macro STM for budget macro work. It is compact, super light, and fits your $500 limit easily.

• 0.5x magnification is solid for jewelry details.
• Built-in stabilization keeps things sharp.
• Native RF mount means no clunky adapters. Its way less intimidating than a heavy 100mm lens tbh...

I spent years hunting for a decent cheap macro and unfortunately, most entry-level options feel like a massive compromise. I once tried an old adapted lens to save money, but it was so heavy and clunky it basically ruined the experience for me. Since you have small hands, you definitely want to avoid that headache. I was actually a bit let down by the magnification on some of the cheaper RF lenses... they werent as good as expected for real tiny details because 0.5x magnification just isnt true macro. I had issues with the Canon RF 35mm f/1.8 IS Macro STM specifically because you have to get so close that you block your own light. If you find the Canon RF 85mm f/2 Macro IS STM on a refurbished sale, it usually hits that $500 mark and gives you more breathing room for flowers.

Just found this thread and wanted to chime in because I struggled with this exact choice when I started shooting my own crafts. Honestly, when I first started, I tried using those cheap macro filters and they were just... terrible. Total waste of cash. If you want something that is actually gonna work without making your head spin, check out the Canon RF 85mm f/2 Macro IS STM. I have used it on the R10 and it is a killer combo for a few reasons:

• It is super light so it wont feel bulky in small hands.
• The 85mm length means you dont have to be an inch away from the jewelry, so you wont block your own light.
• It has great stabilization which helps if you arent using a tripod yet. You mentioned being confused about 100mm... it just means how much zoom the lens has. A 100mm is standard for macro but can be heavy and expensive for a beginner. This 85mm is like a lighter, smaller cousin. I often see them for $499 on sale or refurbished. Ngl, it really changed how my close-up shots looked overnight.

Regarding what #4 said about Helpful thread - i really agree. finding a lens that isnt too heavy is a big deal when you are new. honestly i think staying with the same brand as your camera is the safest bet for macro work. i looked at other brands like sigma or tamron when i started but i was worried they wouldnt be as easy to use or might need adapters. sticking with native canon glass just feels more reliable because you know it will actually work without any weird glitches. it is a decent way to start without making things too complicated for yourself.

Helpful thread 👍