You asked

Is the canon rf s 3 9mm f 3 5 stm dual fisheye worth it?

Here is what the site says about that.

From Canon RF-S 3.9mm f/3.5 STM Dual Fisheye: Canon RF-S 3.9mm f/3.5 STM Dual Fisheye: A prime lens by Canon for APS-C cameras, 3.9mm f/3.5. A twin-lens 3D VR lens for APS-C bodies, with autofocus. Specs - Maker: Canon - Focal length: 3.9mm (prime) - Maximum aperture: f/3.5 - Made for: APS-C sensors - Mounts: Canon RF - Stabilised: no - Autofocus: yes What it frames like - On APS-C (Canon) (Canon RF): like 6.2mm on full frame; f/3.5 gives about the depth of field ...

From Sensor sizes: Is full frame worth it?: For low light, events, and portraits with very shallow depth of field, yes. For travel, street, wildlife on a budget, and most hobby photography, a good APS-C camera with good lenses is enough, and you'll carry it more. Lenses and light matter more than the last stop of sensor performance.

Quoted from this site's pages.

From these pages