I've stayed at POP several times, AS sports twice, and AS Music once. I've also stayed at POFQ mutiple times, PORS once, CBR once, and CSR three times (as well as WL, AKL, and BW). As you can see from my counters, I've pretty much settled on the moderates as my resorts of choice. As far as Pros and Cons:
1. POFQ--Pros: smallest resort on property, so no room is very far from the bus stop or main building, very friendly CMs, boat to DTD, only one bus stop and even though it shares with PORS, POFQ is usually the first stop, jazz music playing a you walk up to the main building, Eliott Dyson playing jazz in the lounge, PORs and POFQ are sister resorts so you can legally use the pools at either resort
Cons: no TS restaurant, rooms could use refurbishment
2. PORS--Pros: beautiful, very peaceful resort with very lush landscaping, very good counter service, decent TS restaurant, (but the TS restaurant no longer serves breakfast), Ye Ha Bob Jackson in the lounge, two distinct themes (the very wooded, shaded Bayou section and the lovely majestic Mansions), boat to DTD, bike and boat rentals, and again PORs and POFQ are sister resorts so you can legally use the pools at either resort
Cons: resort is very big, Bayou section does not have elevators (Mansions do though)
3. CSR--Pros: rooms newly refurbished, only moderate with queen size beds, sliding wooden doors between sink and room, very nice main pool, biggest hot tub on property, sand volley ball court, best kids playground, best bus service of any WDW resort, good food court, three places to refill your resort mug (Cafe Rix, Pepper Market, or pool bar), nice tables right outside the Pepper Market overlooking the lake, by far the most comfortable beds of all the moderates, only moderate with a health club/spa and beauty salon, white sand beaches with hammocks in the Cabanas section and beautiful fountains in the Casitas section
Cons: resort is big, CMs at Pepper Market are not particularly friendly
4. CBR--Pros: centrally located, rooms recently refurbished, rooms just slightly bigger than the other moderates, very nice main pool, pretty white sand beaches
Cons: resort is huge (lots of walking), no elevators at all, bus service and housekeeping were both terrible when I was there. I've never stood on a bus as much as I did the week I was there. Also was not at all impressed with either the CS or TS options, and in fact became very sick after eating at Shutters.
At CBR you can pay for a preferred room closer to the main building, but at the other three moderates you have a chance of getting one close to the main building, even with a standard room. My preferred room at CBR (backside of Martinique #24) was further away from the main building than my standard rooms at POFQ (building 4, four different times), PORS (building 18), and CSR (building 9B).
Even though I am not scheduled to stay at POFQ in 2010, it is probably a close tie between it and CSR for my favorite resort. I love the smallness, the boat to DTD, and the friendliness of the CMs at POFQ, but CSR has the better transportation, comfort queen size beds, and the most deluxe feel.