Hi u/Corruptlol - congratulations on the new BMPCC 6K Pro! If budget permits, I recommend a Canon 100mm macro ($1,299 new or $908.99 renewed with a 90 day Amazon Warranty).
These were shot with the 6K/6K Pro, the Sigma 18-35 and the Canon 100mm Macro:
A few examples shot with the 6K and the 100mm Macro (either by itself or with other lenses):
BMPCC 6K CANON 100 MM Macro| Product shoot | Assorted Fruits SHOWREEL | Bellistar Productions| 2022 (1080p)
"Zoo" - Blackmagic Pocket Cinema Camera 6K- Canon 100MM L by Josh Kidd Films (4K)
Hope this is helpful and good luck with finding the right lens for your needs!