You asked

Is the canon rf 5 2mm f 2 8l dual fisheye worth it?

Here is what the site says about that.

From Canon RF 5.2mm f/2.8L Dual Fisheye: Canon RF 5.2mm f/2.8L Dual Fisheye: A prime lens by Canon for Full frame cameras, 5.2mm f/2.8. A twin-lens 3D VR lens for full-frame bodies, manual focus only. Specs - Maker: Canon - Focal length: 5.2mm (prime) - Maximum aperture: f/2.8 - Made for: Full frame sensors - Mounts: Canon RF - Stabilised: no - Autofocus: no, manual focus What it frames like - On full frame (Canon RF): as marked, 5.2mm. - On APS-C (Canon) ...

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