I think the US News thing is "decent" to a point, but only if you believe 40 and 50 and 60 are pretty much the same as rankings. If you choose some school because it's 45 and you other choice was 52, I think you missed the point. If you see one that is 15 and the others are 70 and higher, it probably is worth considering. But, as noted, many of the factors are nonacademic. You also might be interested in say Journalism and find a lower ranked school that has a highly regarded journalism department.
I think the top 25 or so are better than 75-100. They still might not be better for YOU personally.
One advantage of schools like Harvard and Yale are connections, who you meet while you are there, depending on your major. It might help a lot in business or law, but not help much at all in chemistry or math (STEM degrees). I had a boss once who had a PhD from Harvard. He was a nice enough fellow, but "sleepy". It looks good on your resume, but it may not mean much in the real world.