The Canon RF 24-105mm f/2.8 L IS USM Z stands out for a few reasons; namely, the bright f/2.8 lens is an impressive feat compared to the f/4 speed typically associated with this zoom range.
I think 24-105 is a great choice for full-frame. For APS-C, I don't think 24mm is wide enough. Sony has a 16-70mm f/4 and Fuji has a 16-80mm f/4; those are basically the same field of view on APS-C as the 24-105 on full-frame, and they are made for APS-C, so they are more compact. The RF 24-105mm f/4L has optical image stabilization built in, and it works quite well. Canon rates the IS to around 5 stops of stabilization, and I’ve generally gotten between 4 and 5 stops of shake reduction when using it on the EOS R and EOS RP. This allows for shots of around 1/6-1/4 second at 105mm, which is excellent. A superb general-purpose lens, Canon’s EF 24-105mm f/4 L IS USM is equally at home on the EOS 400D and the ‘full frame’ EOS 5D cameras, giving a focal length range equivalent to 38.4 to 168mm on the former. Compact for its specifications, it is relatively light and comfortable to use as well as being very well built.