Stayed at the CSR in September, I lasted two nights before transferring to the Boardwalk.
The resort is very nice. The Dig Site looked good and the facilities were fine. However, I was not impressed by the room. The Pepper Market offered a good selection of food, but the prices were rediculous.
I had hotel hopped and stayed in the Hilton (Downtown Disney), Renaissance (SeaWorld) and a Condo on the Gulf Coast - so maybe my expectations were set a little high!
Personally, I would recommend splitting your stay up. Try a Downtown Disney area hotel for a few nights and then maybe a Deluxe resort for a few nights?