I thought I'd signed up for every airline & hotel program

but have a reservation for the Delta Bessborough in YXE next month and checked my discounted TA rate and apparently it will qualify as a valid stay, meaning I earn 500 AC AP miles. Has anyone joined
this program and have any feedback? I don't usually stay more than a couple of nights a year with Delta, usually most often at the one across from YYC terminal because of the convenience. Is it worth it without being anywhere near the elite levels, or should I just forgo enrolling and simply present my AP card at check-in?