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.