In my experience…
soft rims* = dents easily but normally holds a seal, sometimes if you really bend it good then the bead wont seat properly.
hard rims** = rarely dents but pinch punctures a lot more easily and puts holes through tyre bead/sidewall
I’ve found the pinch punctures from hard rims happen more frequently than the soft rims not sealing for me, so I tend to take the hit (no pun intended) of dents now.
Both require a tube if it happens on the trail, but one leaves a hole in my tyre and the other doesn’t, and it’s often easier and quicker to bend a dent out at home than stitch and patch a tyre.
Stans may be a good half way, I’ve only got them on one bike thoguh and only put a couple of hundred miles on them so far, so not really enough use to comment at the moment.
*DT Swiss(cheese)
**Maxtal Mavics are hard as nails.