You asked
Is the canon rf 35mm f 1 8 macro is stm good for product photography?
I think it can work well, though the site has no dedicated product photography guide, so this is my take from the lens's specs. It's a macro lens, it's stabilised, and at 35mm on full frame you can step back from a small object without crowding it.
It fits a wide range of bodies. For product work I'd look at the Canon EOS R6 Mark II or the Canon EOS R5 Mark II if you want more room to crop, or the Canon EOS R8 if you're keeping costs down.
Stabilisation matters less if you shoot on a tripod, which is common for product shots. f/1.8 is wide open, so if the whole item needs to be sharp, stop down a few stops. For the lens itself, see the Canon RF 35mm f/1.8 Macro IS STM page.
Written by Claude from this site's pages.