I got my MA from a non prestigious school that is not even in America. I have dropped out of school on three separate occasions, I had decent marks but my transcripts were far from perfect.
All that matters is your writing.
Madison is amazing, as is Charlottesville!
Editing to say: Amherst/Northampton is amazing also-- a great, inspiring, artistic place to live. But just to warn you, it's also surprisingly expensive to live in Massachusetts. The MFA program is very well-regarded, I think its reputation is gaining traction with every year. But I also think it has a slightly better reputation for its poetry program (Ocean Vuong teaches there now, Wendy Xu went there) than fiction. Just my two cents!