Sure! First of all, the only Disney hotels we've stayed in are Shades of Green & Contemporary, both of which are deluxe level hotels, so keep in mind that is the viewpoint we're coming from. When we vacation, typically our preference is to stay in a higher-end hotel, even if it means a shorter vacation. Since the military tickets are five days, and experience has shown us that we personally can't go five days straight without a break day, we opted for eight days (including travel days), which is longer than we perhaps would have otherwise. A deluxe level hotel would have been $1k more, so we chose Moderate.
Our initial reservation was a spur-of-the-moment, no-research, "I must get a hotel NOW before there are none left!" type of decision. We had a family meeting yesterday morning, reviewed our options (including going Deluxe and otherwise having less spending money or going Value for even more savings), decided on Moderate, then further looked at the options in the various hotels to make our final decision.
The two main factors for us in choosing CSR were 1)
newly renovated rooms (we'll have a better chance of a renovated room since we're not going until October), and 2) queen beds. There are three of us (DH, teen daughter and me), and again, experience has shown us that we're not comfortable on a vacation when we have double beds. Additionally, we overall prefer the decor of CSR (which is obviously subject to personal taste).
From everything I've read, it's obvious that CSR isn't for everyone (I'm not sure I'd stay there if I had a small child). But for us, it seems like the best fit.