I can weigh in on University of Michigan. I applied in my last year of undergrad (got a BSW, so it was for the advanced standing program). I am an out-of-state applicant. I got in. They only gave ~9.5k in aid. I deferred to Michigan for two years, and planned to work to save money (lol, I did not save any money living in NYC for two years). When I did the FAFSA the second time I was no longer being claimed my parents on their taxes and I was making under ~$40k a year. Michigan gave me a $39.5k scholarship towards my tuition. It was unreal to get that letter. I had a 3.36 GPA/3.89 in my major (social work), good research experience, but at the time I got the larger scholarship money I had already gotten accepted so I don't know if it was a factor.
I had a phenomenal experience at Michigan, even though it was short (one year for AS students). I also would've paid more had I lived at home and gone to my in-state MSW program. I tried to apply to research assistant positions but they're usually reserved for doctoral students. I got a "paid" field placement instead (it paid $10/hour for 20 hours a week so it barely covered my rent). I did take out federal loans and mostly lived off those. It was financially challenging for sure, and I'll probably be paying loans till I'm 40 but I can honestly say I have no regrets. Hope this helps, and good luck!