We've really enjoyed our two visits to CSR--once in Cabanas and once in Ranchos.
IMO, Cabanas location is best, close to both the Dig Site pool and to El Centro (main building, Pepper Market), but we didn't really mind being in Ranchos--there is a bus stop at every section, and the walk from Ranchos to El Centro was very pleasant, past the Dig Site and around the lake.
The Pepper Market has lots of tasty food choices. The card punch system takes a little getting used to, but IMO better than separate lines and cashiers for each section as at other food courts. Also we didn't mind paying the 10% to get drink refills and to eat with real plates and silverware (not the plasticware in other food courts). I understand they will take off the 10% if you complain to the cashier.
Bus service was excellent on both our trips--CSR doesn't share with any other resorts.
Some folks worry about the conventioneers (CSR is the only moderate-price Disney convention hotel) hurting the atmosphere, but we didn't really notice them unless we were in El Centro, and it didn't bother us at all.