A yes for CCs here
I'm a big fan of the protections built into CCs, one having saved me $15K from a crooked contractor some years back... I also find value in airline (or other) cards that give airport lounge access. Very helpful when I had a several hour delay at the Las Vegas airport. One lounge closed at 11, one at midnight, but I had access to both, which alleviate some of the misery of a delayed flight.
One of our cards has great concierge service, getting us into places that tell us there's nothing available. Not a big benefit for most, but when you need it, it's nice.
I'll be taking DH to Europe for the 3rd time in April...all on FF miles. Again, not something that everyone would care about, but we value that.
Mostly, though, I love being able to pull up purchases. Very helpful at tax time, or when trying to figure out if I'm within a warranty period. Or just to crunch budget stuff, like trends in our eating out. Those statements spin out a lot of data, which I find useful.
It does have to be approached (IMHO) like a hobby, using miles, discounts, benefits, etc. associated with each card. And it's not for everyone, for sure. It works for us, though. I don't notice any increased spending with CCs, since I know we'll both be going over statements every month. I do note that if I'm using cash, I don't think about it as much--like it's just "paper" with no accountability attached. I feel much more accountable with statements in front of me.
A very YMMV situation.