Matt,
CC was pretty firm when I was there. Its monsoon season now, so maybe they've had quite a bit of rain. It certainly wasn't soft, but I can see how that would make quite a bit of difference. I was very impressed with the conditioning the the way the course played. I can tell you it did not seem wide when it was rolling (some holes were generous, but others not).
I do agree they need a set of tees in the middle. Even a combo set of the existing tees would be fine. The tips are too long for most of us, and then the next set plays fairly short given the elevation.
Lakota does have the repetitive bowl green aspect to it, I agree that's the biggest negative. Red Sky though has EVERY non-par four playing in the same general two directions along the mountain. Yes, if you hit the low side of the fairway you may have problems, but I totally disagree with your "ball position in the fairway" comment--if you use the slope on the high side a good portion of the time it comes back, and if not you're usually very safe. Awkward lies do add to the experience, but talk about repetitive. A couple of uphill/downhill holes other than the par threes might have made things a little more varied. Not to mention that I do agree that at few holes at Red Sky Norman are bunkered to the extreme, what's the point of the minefields on #7 and 13 other than looks and to catch horrid shots or the weaker player. Its a strong course with many good features, don't get me wrong, and probably the most difficult of the three which tends to fit your liking from what I can tell, but not the most fun.
Anyone interested in the financial aspect could also play Lakota, Cougar, and Redlands for the price of one round at Red Sky approximately. I'm not considering that for the architectural comparison, but if I were to choose where to go back it would come into play. Heck, there all good courses.