I have very rarely been automatically upgraded to a suite room at a CY. But I have had very good luck at getting a suite room by asking when I check in. I will usually check the online tool just before I check-in to see if they are showing any suite availability. If there are some listed, I seem to have had a good chance at receiving one.

I have had 3 stays this year at two different CYs both in the Auburn Hills area of MI. My stays were about 5 nights for each, and I was upgraded to a suite room for all 3 stays. ^