Similar to others....it's seems to be completely hit or miss. That being said, I typically get the cards and present them to the clerk at check-in. If they take it, great.....if they don't, I'm no worse off.
We certainly spend enough time in these hotels.....might as well try and get a little back from them. Funny thing is, the more they cooperate and try to get me some points, the more likely I'll book w/ that hotel when I'm traveling on my own.