It depends on the card and the reason for the sign up. A lot get changed to another card once the af hits, which has been discussion tonight with the freedom cards.
I'll keep my Hyatt because so far the free anniversary night value is well over the af for me. I'll keep my csr because the travel credit and other benefits justify the af for me.
I won't keep the delta amex biz once the af hits because I don't fly delta enough to warrant the fee but the sign up bonus was too good for the msr to pass up. I'll probably cancel my Alaska card either for a biz or to churn it when the ad hits unless they give me a good retention (haha I doubt it).
Oh and my cfu doesn't have an af so no reason to cancel which is what many do unless they plan to churn the card but generally the signups are low on no af that there's no reason to waste a x/24 spot on it if you aren't keeping it, some will say better to pc to one.
Really everyone will give you a different answer, even to the above cards
ETA phone's autocorrect didn't correct the one word I actually misspelled vs all the acronyms it wanted to change.