I disagree that someone can’t feel lost in the crowd at a big college. It feels overwhelming to many people. That is the primary reason why I never made acquaintances at my big state university. I didn’t know where to start and so I tended to hide out in the library between classes. My friends were people I worked with. I wish I had had the opportunity to attend a smaller college.
Holy Cross has excellent name recognition in the Northeast, where most publishing houses, including the Big 5, are located.
A quick AI search (not verified) says that a U Michigan grad who goes into publishing can expect a salary of $45-55K. A Holy Cross grad can expect to earn $50-60K for the same kind of job.
https://www.indeed.com/cmp/College-of-the-Holy-Cross/salaries/Writer
https://www.indeed.com/cmp/The-University-of-Michigan/salaries/Writer
The same type of job salary appears to be lower for Michigan grads.
Consider if you prefer to be a big fish in a small pond, or a small fish in a big pond. You will have to work much harder to get invaluable professor recommendations at Michigan. You will be competing with many more students to get jobs, research positions, and internships.
The College has good outcomes for its graduates.
In the last ten years, Holy Cross has moved in USNWR from #39 to #27. That number reflects its growing reputation. If you plan to stay in the Northeast especially, you will find that employers will know the name of your college. This is not a second rate college.
https://www.usnews.com/best-colleges/college-of-the-holy-cross-2141
Good luck. Students consider transfering for many reasons. Often those reasons make sense, as in this thread: Should I transfer to Drew from Binghamton?
You are not in a similar situation to the student in that thread. For you, it’s more like a case of “it ain’t broke, so don’t fix it.”