The bigger dishes are used because at 3.5 - 4 ghz, you need 'em to get the narrow beamwidth for close-spaced satellites.
At higher frequencies, smaller dishes can have sufficiently narrow beamwidth without being so large.
If it was not for adjacent satellites, I think a lot of C-band could be received on 4-foot dishes.
And then there is the annoying poor-FEC systems!
Those where you need the cleanest signal because there is very little error correction.
And adjacent satellites play a role in that problem, so tuning them out, gives you the sufficient signal to noise ratio (low bit error rate) to decode such carriers.
Newer encoding schemes likewise put a strain on the quality of the signal.
And of course, some satellite transponders are just weak.
As for what you can get, ask the guys on 4' dishes.
Or, look for the posts by Iceberg, concerning his 6' dishes.
I think instead of bitching about what he can't get, he enjoys what he can.
So, his cup is half full, not half empty.
I've got my eye on several interesting commercial solid 6' dishes, if an 8' doesn't come bite me in the butt first!
You might also search the FTA forum for previous discussions of what a six foot dish will yield, for more info.