In my case I would keep the CSP and the Ink and try to rotate each year getting retention bonus' on the cards.

I'd keep it for entirely selfish reasons though. I love then design and before I even started on collecting points obsessively it was the only reason I applied for the card. However, in truth the 7% dividend is highly unlikely to justify the $95 annual fee so if you have no attachment to the card aesthetically then taking sftravelninja's suggestion of getting the standard Sapphire card without the annual fee is the better option.