After doing all the research, I have come to some conclusions and these are my findings which I hope will help others:
1. If your family income is less than 60K, or 40K depending and you have stellar grades and SAT/ACT scores, you pretty much can pick any school and get a low cost education if admitted.
2. University ideal student = High grades/scores + high family income. Its the Robin Hood story. If every high performing kid gets a scholarship, who pays? Remember its a zero sum game.
3. Full tuition/everything in top 50 schools = Very rare and competitive.
4. Read the fine print. Eg Cornell U say they will provide no more than 5K loan for family income less than 120K. That 5K is for the student and family is expected to fork out a large portion.
5. Either you are in the Ivy or not, there is no significant difference between the 15th and the 50th university in the workforce. But a grad degree makes a difference.