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.

From these pages