Among the moderates, I must confess that Caribbean Beach is my favorite resort, and it does indeed have an amazing pool. In fact, I'd say it might be the best pool outside of Stormalong Bay at the Beach Club. The pools at the other moderate resorts quite honestly will not compare, so be prepared for that.
However, Coronado Springs is my second-choice moderate. It has been recently renovated with an upscale feel, and I like their food court, the Pepper Market. We also like their themed pool with the giant pyramid - great photo op! But size-wise, it's not much different than Caribbean Beach. They are both very large resorts, situated around a lake, which makes for a good bit of walking.
If small is what you're after, then
Port Orleans-French Quarter is your best bet. It is by far the smallest of the moderate resorts, and it has an excellent food court as well! The themed pool there, while smaller, boasts a large sea serpent in the water which often impresses the kids in the crowd.
And really, wherever you stay, you're still in the most magical place on earth, so I'm sure you'll find reason to love it!