I've been picking away at a response for a few days now, but hadn't had a chance to get my thoughts fully together.
To me, there's not one better than the other. I fall on the side of preferring slides, but there are plenty of downsides to shooting them especially in 2024. The film is expensive, the selection of emulsions is limited(granted that's true of all films...), processing is more expensive, processing is harder to find, good processing is even more difficult to find(especially as there's more chance for things to go wrong) and home processing is longer, more involved, and more fiddly.
Modern C41 emulsions are really darn good. The current Portra films, as I understand it, share technology with Vision 3 pretty heavily, so are arguably some of the most advanced films out there(and Vision 3 has Hollywood money behind it). They have a ton of dynamic range-on par if not better than a lot of digital cameras-and are super easy to scan. Ektar is a little more fussy, but still a great film.
I tried to find some information on grain, but Kodak seems to have changed their method of evaluating grain on color negative films. The old method was RMS Granularity, and the best slide films I'm aware of(Provia 100F and Kodak E100/E100G/E100GX-AFAIK E100 really is just E100G with some tweaks for longer shelf/storage life without refrigeration) have an RMS Granuality of 8. Fuji Velvia(RVP)/Velvia 50(RVP-50)(the former is the "original" Velvia, the latter the relaunch on the new base but allegedly the same) has an RMS granuality of 9 from what I remember. Without looking it up, I seem to remember that the other Velvia offerings(RVP-100, no more in the US, and RVP-100F, gone for good I think) are 9 also. Astia(RAP) was/is 9.
I tried to dig back and find datasheets for the previous generation of Portra also(160NC, 160VC, 400NC/VC/UC) and all it lists too is the print grain index.
I did find something interesting, though. Fuji NPS, which I think would be roughly comparable to Portra 160NC/current Portra 160, lists its RMS Granularity as 3. That makes me wonder if they measure print film the same way...
Whatever the case, I come back to slide film for two reasons. The first is the color. Ektar 100 is close, but I've never found that I can get quite the same colors from Ektar as I can from E100 or Provia, much less Velvia. Slide film also gives you an absolute color reference-you can lay it on the light table and see exactly what it looks like. The second is that I love direct viewing of it, something you can't do with any other film.
I remember back in 2005 or so shooting my first roll of Velvia(and at that point in the US, there really was only one Velvia). I'd dropped it off at The Film Lab in Lexington, KY, which guaranteed same day processing if they got it before 10:00AM. I killed time around town, went back at 2:00, and they handed me two Printfile pages of mounted slides that I put on the light table their in the lobby. I'd not seen anything like it before, and I was hooked from there.