“if I could get into a “better” school like an Ivy League school, would it be better to go to the school that has the top-rated grad program in my (expected) field so I can make a name during my undergrad time and maybe get into my ideal graduate program”
Mostly no to this part. In my experience the students in the graduate programs in top-named schools come from a very wide variety of undergraduate schools. When I was a graduate student at a highly selective west coast university, I don’t recall there being two students from the same undergraduate school for any school except for Rutgers, and that might have been a fluke largely due to there being a large Bell Labs contingent at my school back then. What the graduate students at the top-ranked university had in common was a very strong GPA as an undergraduate.
Also, getting into any Ivy League school as a transfer student is an extremely long shot.
If you are going into a field where graduate school is needed (which includes sociology), then you need to minimize debt for undergrad. The University of Michigan and Michigan State are great schools and if they are in-state should be relatively affordable if you can get in.