You asked
Is the canon rf 100 400mm f 5 6 8 is usm worth it?
Here is what the site says about that.
From Canon RF 100-400mm f/5.6-8 IS USM: Canon RF 100-400mm f/5.6-8 IS USM: A zoom lens by Canon for Full frame cameras, 100-400mm f/5.6-8. Light and cheap reach; dim at the long end, so it wants good light. Specs - Maker: Canon - Focal length: 100-400mm (zoom) - Maximum aperture: f/5.6-8 (it gets darker as you zoom in) - Made for: Full frame sensors - Mounts: Canon RF - Stabilised: yes - Autofocus: yes What it frames like - On full frame (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.