Without getting into a debate between Marriott Rewards and HHonors, those of us here who pick Courtyard over its mid-price competition, generally do so because Marriott Rewards is our first choice among the rewards programs (for various reasons), and because for many of us it's not easy to get the 50 or 75 nights required for true elite status. On the other hand, many folks agree with you as to Courtyard being the poorest value in the Marriott pecking order. In general, I find it no better, and sometimes not as good, as Garden Inn or Hampton, depending on the location. You are also correct, and it is a frequently mentioned sore point here that Courtyard, unlike its competition, doesn't provide comped breakfast; not even to elites.
I would note that, apparently unlike the CY you stayed at, many have been renovated, and most have new good bedding.