Not much in the way of upgrades at Courtyards, because there really are so few rooms that differ from the norm. I have gotten suite rooms before, and on occasion a "spa" room, but I would say that I probably get upgraded at CYs about 1 out of every 10 stays, if that.
I look at it like this - earn at CY, burn at nice places. The great thing about being plat is that when you book reward travel, you probably won't be staying at CYs, but will still be eligible for an upgrade. Always nice to arrive to a suite room in a fancy city.