There are many schools full pay and / or with merit that are good deals.
Ranking isn’t necessarily relevant - to each their own.
But you can go to well respected flagships in the 20s, in the 30s, etc.
I don’t really see the relevance of studying this - because with auto merit, you are missing many schools - but that would be based on each specific student, which you can’t capture.
And every person’s budget is different.
Just my opinion.