I can't think of any time I have been asked for a AAA card upon check in in the past few years. Generally HoJos, Starwood, Hilton and the Comfort Inn up in Freeport Maine (as often as I can go with my kids).
I don't even carry my AAA card with me. I have my number and the phone number in my Blackberry.