I found the RF24-105 to be always a good enough focal length range whereas the 24-70 never was long enough.
In the 90s we really needed f/2.8 to fully enable autofocus, to have a bright viewfinder, and because fast film and slow shutter speeds looked absolutely horrible, and because film was anyway so grainy and lenses less sharp that the blurriness from shallow DOF wasn't so obvious. In contrast, with the R and especially R5, there's just no reason for f/2.8. Photos are so clean and sharp that the gentler bokeh from f/4 is still really noticeable and makes your subject stand out, and still is enough to differentiate the look from a cell phone photo. Super-high ISO and super-long shutters are no longer a problem, and AF works fine and the viewfinder brightness no longer depends on f-stop.
On an R5 the 24-105 is actually almost "smallish".
When I first got the R I got the 24-105 and 50/1.2, and after a year had only taken like three photos with the 50! So I sold it. After about 4 years with only the 24-105, I got a bunch of other lenses last year (I used to have 15 EF lenses in the 90s-10s) and don't use the 24-105 much but mainly because I have other lenses to explore. But frankly most of my good pictures would have been nearly as good with the 24-105.
If I hit hard times and had to sell most of my Canon gear, the 24-105 would be the last lens I'd sell. It's not a lens I love, but it's one that really works well for everything except obviously telephoto. It's not super-wide but it's wide enough. It's not super-sharp but it's sharp enough. It's not super-bokeh but its enough bokeh. It's not super-compact but it's compact enough, etc. etc.