I've stayed at a value, moderate and deluxe resort.
Started with YC concierge (FTP in August, 2003 made it affordable), which was wonderful. A friend and I were emerging from a difficult few years with out families and needed time for ourselves. I've stayed at far more elegant hotels with better rates (not WDW), but this suited our needs at the time. Proximity to EPCOT and Disney-MGM wasn't shabby, either!
Disadvantage was sharing buses with S&D and BC. Even when the buses weren't crammed to the gills, the trip was longer due to the extra stops.
Then stayed at CSR, water view room in December, 2003. It was the only room type available on an AP rate when I finally booked early in November. CSR vanity has only one sink, FYI. All of the other moderates have two.
Overall, loved the resort despite the size. Not fond of the food available, but I'm a picky eater. Hammocks on the beach, watercraft and bicycle rentals, terrific pool and children's play area. Gorgeous sunrise and sunset views! Great bus transportation. Four bus stops, but the buses are not shared with other resorts.
Disadvantage is size of the resort. It covers a lot of territory!
December, 2004, did a budget trip and stayed at Pop Century on an AP discount during value season. Very neat, clean and compact rooms. Certainly adequate for my solo traveler needs! Room smaller than moderate, food court had a reasonable range of foods, although it didn't appeal to my finicky tastes! Don't let that deter you, though--I really am a horrendously picky eater! I actually used my rental car quite a bit this trip, as I was with a large group and it was easier to arrive at meets on time! The times I used the bus, it was fine. Buses were horrendously crowded after closing down
MVMCP (I waited until well after the crowds left the second night I attended), but that's true of the buses for the deluxe and moderate resorts, as well. BTW, the soundproofing between rooms at PC is very good. I've heard complaints from people who have stayed at the All Star resorts about noise from adjacent rooms.
It's really a matter of what meets your budget and space needs when you visit WDW.