Lower value caps = less treble rolloff as you turn down...or, rather, a rolloff of higher and higher frequencies, making it so as you go down in value, less and less of the midrange is lost when you turn down the pot.
Imagine a graphic equalizer with 20 bands, low frequencies on the left and high frequencies on the right. For sake of illustration, let's say a 0.047mF cap causes the tone knob to pull down sliders 9-20, leaving 1-8 unchanged. Then a 0.022 cap would change it so that the tone knob only pulls down sliders 13-20, leaving 1-12 unchanged. And a 0.01 cap would only pull down sliders 17-20, leaving 1-16 unchanged. See what I mean? As you go farther down with cap value, the cutoff point for what frequencies the pot will affect is shoved to the right.
That is why I prefer lower values for the most part. They make so your tone knobs pull out only the higher frequencies, while leaving the lower ones unmolested. The tone knob becomes more like a treble reducer than a treble and midrange reducer.
It's a matter of trial/experimentation to find what works for you. I keep going lower with cap values until I get tones at both 0 and 10 that I might actually use from time to time. That places my "normal" tone somewhere in between the two.
250K pots and 0.047mF caps might work OK in some twisted electronics tech's mind, but not in reality IME. IMO it is too much rolloff, even for something like a '50's wind Strat bridge pickup. It makes your tone pots practically unusable for anything but a heavily muffled jazzy tone. I just realized that that dumbass combo came stock in my Aerodyne Tele, and got rid of it. I went to 500K pots, and tried 0.022 caps, but still too much rolloff for me. I can use the tone controls down to about 5 (which is an improvement), but anything lower is too muffled. 0.01's are the next step, and I would have gone straight to them if I had had them lying around instead of the 0.022's. But at any rate, the guitar actually has a usable neck pickup now!
My favorite combo for most humbucker equipped guitars is a 1Meg pot and a 0.01mF cap, and 500K/0.01mF for Fender single coils.