03Ltd.Windstar- Welcome to Autopia!
I agree, cheap and reliable, with money left over for snow tires. IMO when you're in college the last thing you need to be thinking about/spending time on is your transportation, what matters is that you get where you're going on time and in one piece.
While your friends have had bad luck with Hondas, that's unusual- most of 'em are very reliable.
I'm a big fan of AWD, so I'd recommend a used Subaru, despite both of my Subies being unreliable (again, that's unusual and you gotta go by the overall trend not idividual cases).
A new/newish Mazda might be *too nice* for this application. Would you be able to "neglect it" (in the Autopian sense) when you're busy with schoolwork?
Make sure that your choice can be conveniently serviced, this gets back to the whole idea of not making your transportation a big priority for the next few years.