No idea what those rankings mean, OP, but personally, I want the very good but not necessarily top schools. That's because I want a student body that's motivated but not too pressured, and I want good teachers. I've noticed that the best teachers are at either end of the spectrum - in the lowest performing schools, for the challenge and impact they can make, and in the highest performing, for the ease of their job (students who care with invested parents).

what kind of rankings are you referencing? I don't think most people know those numbers. If anything, people are familiar with Great Schools numbers, but not the specific school digger number (if that is what you are talking about). People's ability/interest in comparing is usually geographically limited.... knowing that your school is #845 means nothing unless the nearby schools are #102. People make their choices within a limited geographic area.

Anyone with experience who can share?

Example : K-3 at a school ranked 315 and 3-6 in the 875. Out of 1,000+