I go with mostly cash-back rather than points or miles. Exceptions are Citi AA Visa and Chase Sapphire Pref. I bagged these for the sign-up bonuses.
Since the coin deal has expired I'll probably drop the AA Visa, and may drop the Sapphire once the fee kicks in. I too have a low rewards card I have held for 30 years, just to keep my history. I tend to hold rather than churn, so I keep cards for years, only dropping them if they change the deal - gut the rewards.
I do churn what gets wallet-space. Discover and Chase Subaru MC have capped rewards - high percentage but only for a relatively small spend. I spend to the cap then stick them in my safe.
My default CC right now is my Citi No-hassle cash back. 1.25% in dollars. No foreign currency fee. They can't devalue dollars at the issuer's whim, the way they devalue points or miles.
But I am looking for a deal to replace the coins to pump up my spend.