What majors are these colleges good for?

You should be doing the opposite. You should see what you want to do and then see which colleges are good in those categories, not the other way around.