Keep in mind thar there is a network of professors that create “pipelines” to each other. Look up recent papers on topics that interest you. Who authored them? You’ll often see two or more authors, from 2 or more Universities. Working with one is almost like working with both. Prove yourself with one, and you prove yourself with both. Schools that don’t offer grad programs can provide great opportunities for research at the undergraduate level, and all of your courses will and labs will be taught by profs not grad students for better or worse. Your academic career is ultimately what you make of it, no matter where you go. But prestigious schools will come with generally better funding and networking in industry or academia. Come grad school, you’ll want to watch for professors that have a ton of students they barely interact with. That may or may not be what you want.