The one and only thing I don't like about CSR is the food court and it's pricing. It's very pretty, has a great gift shop and is a nice place to return after a day in the parks. None of the hotel/motels at WDW seem "too big" to me. CSR is bigger than POFQ, for sure. If you're in a room furthest from the food court/gift shop and you'll be going there a lot, you might consider it too much walking. If you have a car, you could always drive it.
I wouldn't pick a hotel based on proximity to any one place. Disney is big, but if you're driving, it's always a matter of minutes. A hotel that is close to one thing will be further from others. I would pick my place based solely on whether I liked the looks of the place and the rooms.
POFQ is a distance from AKL, but if you're driving, it's a matter of a few minutes. If you are taking the bus, going from one hotel to another will take a lot of time, no matter where you are going. The busses don't travel from one to another. You must transfer, which means waiting for two busses. Disney always tells people to allow 60-90 minutes travel time. They aren't joking!