Depends what you mean by "good". Do you mean those that perform best in the league tables? If so then the two main independents, Birkdale and Sheffield High, out-perform everyone else.
In the state sector, the best from this point of view are Silverdale, Tapton, Bradfield, King Edward's and High Storrs. Silverdale usually comes out on top, with the others jostling for position in the top 5. There is a vast tranche of schools in the middle and a cluster at the bottom which are awful - if I were in your position I'd be looking to avoid Chaucer, Hinde House and Myers Grove.
A couple of the "worst" schools, Myrtle Springs and Waltheof, have recently re-invented themselves as "Springs Academy" and "City Academy" respectively. It remains to be seen if a new building and nice new uniforms magically transform these schools into high achievers, given that they are working with the same "raw material", i.e. kids mostly from low-income council homes.
Are you thinking of moving? Be aware that the house prices will reflect the popularity of these schools - all on the western side of the city - and can add sometimes up to an extra 50% on the price of a house.
Often, people's school "decisions" in Sheffield seem to be borne out of a desire to escape a particular catchment rather than to "get into" one particularly.
However, it's possible that you may be looking at criteria other than simple academic "excellence" (which is a very dubious thing anyway). In this case I salute you. It's harder to determine which is better for your child - the only way is to visit some schools and talk to parents who have children at them.
Hope this helps!!