Big sis was at Lupton so I can tell you about that. Its not as nice looking as some of the other halls, and its a little small BUT it does the basics fine and I personally think (as does my sister) its value for money. Its no worse than other cheap halls I've seen at other unis, and the toilet ratio is decent imo (1 bathroom to 4/5 people)
It's about a half an hour walk to the campus, but its around £1 for a bus to campus (one way) and £2 to the station/city if you don't like walking
In terms of going to the city, there are night buses to Headingley up to like 3AM but taxis are pretty cheap if you team up anyway despite the extra distance (sister says if she gets a taxi for 6 its like £1-2, cheaper than the bus)
Plus its right next to a Sainsburys (as well as other places like KFC), and they're opening a Morrisons right next to it too so its not going to be a trek to do your shopping. And being in Headingley, its near lots of other pubs/bars etc. the Otley Run's in Headingley! as well as restaurants and things too.
Also worth noting my sister gets on very well with her flatmates and another flat and they often have like group dinners/parties or something, so it seems pretty social despite not having a common room or whatever. Maybe just a little more effort to knock on people's doors and something lol.
I can't think of anything else lol, I guess it depends on your personal taste i.e how far you're prepared to commute, if you want a a big room/bed etc.
I know nothing on MB except for its much closer to the campus, but more expensive. So I hope this helps