Just catching up on this thread and honestly, with that $900 budget, you might want to consider going the refurbished or used route to get the top-tier glass. Since your trip is next week, buying new from a local shop is probably safer than risking a delivery delay.

• I would suggest looking for a used Canon RF 100mm f/2.8L Macro IS USM. It hits the $900 mark occasionally on secondary markets and is the gold standard for the R6.
• If thats too pricey, be careful not to overlook the Canon RF 35mm f/1.8 IS Macro STM. Its way under budget and very light for travel.
• Make sure to check the magnification. The 35mm is only 0.5x, so for tiny bugs, it might not be enough.
• Always test the autofocus in the shop. Even native glass can hunt if the subject is too close. Might be worth checking if a local rental place has one too if the shipping doesnt line up.

Just saw this while getting my gear ready for a morning shoot. If youre done with adapters, honestly the native RF options are a breath of fresh air on the R6. Since you have $900, you actually have some great choices that wont break the bank.

• Canon RF 85mm f/2 Macro IS STM: This is my daily driver for light hikes. Its super sharp and the stabilization works like magic with the R6 IBIS. Only downside is its 0.5x magnification, so for tiny bugs, you gotta crop a bit. But the AF is snappy enough for active insects.
• Laowa 100mm f/2.8 2x Ultra Macro APO RF Mount: If you want those crazy bug eye shots, this is the one. It goes to 2:1 magnification which is basically twice what most lenses do. Its fully manual tho, no autofocus, so youll be rocking that focus peaking on your R6. Its very solid and heavy, feels high quality.
• Canon RF 100mm f/2.8L Macro IS USM: Okay, this is slightly over your $900 brand new, but I have seen used copies or open boxes hit the $950 mark lately if you look around. Its the gold standard. 1.4x magnification and the SA control is kinda fun for artsy stuff. Ive been so happy moving away from the EF-RF adapter for macro. The weight balance is just way better and things feel way more integrated. If you need it by next week, maybe check if a local shop has the 85mm in stock since its cheaper and gets you going right away. Ngl, the native glass just feels more reliable when youre out in the field.

> im so frustrated with this janky adapter setup its literally ruining my macro shots Dude, I feel your pain so much! Nothing is worse than watching the perfect shot fly away because the focus motor is hunting or the adapter just decides to glitch out. It drives me absolutely crazy when you finally get the lighting right and the gear just lets you down like that! If you can stretch the budget or find a deal, the Canon RF 100mm f/2.8L Macro IS USM is literally a dream compared to that adapter struggle. It locks on so fast, honestly it feels like magic. But if you need something lighter, the Canon RF 35mm f/1.8 Macro IS STM is also a blast to use for street and macro stuff, tho you gotta get pretty close to your subjects. I just want to toss my adapter into a lake sometimes, seriously. Good luck with the trip next week!

Honestly, just go with a native Canon macro! I love mine because it's so reliable and easy to focus! Canon glass is definitely the safest way to go!