Tricot! I live in a tract of orange and red too. It isn't considered a fashionable or desirable area by many people, and yet it has excellent transport links, close to great parks, good primaries, good comps, I am v happy with our closest, would have been very happy with our next closest, had an option for a good nearby school which admits by lottery.
We could have made life stressful at secondary transition, by going for one of the super selectives within reach, a poster further down talks of Graveney and other schools which are actually miles apart, and once you start striving for the one place everyone is talking of and competing for, then it becomes both hard and complicated. And also not always worth the stress. There are comps which do almost as we'll as Graveney in terms of the top band, without the benefit of a highly selective intake, but the imperative to get into a super selective seems to take over for some people.
I have friends from high achieving mc families whose children are all doing extremely well in London comps which you never hear discussed as 'must get into' Schools. Haggerston, Lambeth Academy, Rutlish, Norbury Manor, Sydenham Girls, Prendergast, Harris Boys E Dulwich, Pimlico. Elmgreen, also Charter, Dunraven, Kingsdale.
It is difficult if you are in one of the 'black holes' or trapped in the centre of a load of genuinely bad schools. There are schools in our area that I would have been keen to avoid.