I'm also a first year at Newcastle, hopefully I can provide as much advice as possible, I know student accommodation can be ridiculously overwhelming!
I wouldn't call the accommodation 'poor', I think most are actually rather nice, although in my opinion there are some you should avoid - it all depends on what kind of thing you're looking for. These are just my opinions though, please don't take them as gospel - I'm only trying to help!
Bowsden Court are lovely flats, the interior is all newly refurbished and very modern, so if you reckon you'll be spending a lot of time in your flat this is ideal. However, it is very quiet as it's fairly small and there aren't many people there, meaning its not as sociable as other halls - I've heard that you make good friends with people near you but it's harder to meet others as there's less parties etc. Also, you will have to use the Metro to get anywhere good really (eg the city centre or the Uni) so if you're not okay with that, I wouldn't recommend it.
Castle Court is quite similar to Bowsden Court, lovely interiors. Although again, the halls themselves are pretty quiet and it'd take a trip to neighbouring Castle Leazes to go to the more rowdier parties. Castle Court is usually inhabited by people with a similar, rather well off background (not saying this is a bad thing at all, although it can sometimes feel a bit 'rah' like!). They do get good social events such as a ball etc which sounds tempting, but most of your courses and/or societies will also offer this so don't get hung up on the fact that they have occasional activities within the halls!
Castle Leazes I really wouldn't recommend! The reception area/shops etc are all lovely and shows it does have more facilities than some other halls, but once you get to the room they are very grim! Castle Leazes works on a 'corridor' basis rather than a flat, so you don't have a living room and usually have two bathrooms and one kitchen between about 10-15 people on your floor. I've found that, although it does have a good party reputation, it can be more unsociable! The kitchens are well refurbished, but small and means it can be harder to throw a party as there is no 'flat'. Also, if you end up on a floor with people who stay in their room all the time, it can be very lonely. The lifts smell of urine constantly from people coming back from a night out and some signs are written on in marker pen. It looks VERY hospital like, although as the corridors are so narrow and badly lit, it does not feel nice! However I would disagree it's full of rah's, its actually a nice mix of backgrounds and nationalities!
Central Link's flats are gorgeous! It's a brand new building literally next to the business school, but WORD OF WARNING - if you're doing a business course, your first year lecture are not held in the business school, they're held on the main campus along with everyone else (eg armstrong building, bedson building if you're wanting to map it) so don't pick it for convenience! It's very expensive but you do get what you pay for, the facilities are great and very advanced! The main bad point would be that it is VERY hotel-like - for the first three months here, I actually thought it was a hotel! It's also very tall (I'd guess 15/20 floors) so if you don't do heights or lifts don't pick it.
Henderson Hall is a bit of a question mark. In my opinion, the images and tours Newcastle Uni provide are a lot better than it looks in real life, whereas other accommodations are relatively realistic! It's one of them accommodations that are just 'alright' - nothing majorly good or bad! However it is the furthest out and situated where most 2nd/3rd years student houses are, so whilst it's possible to commute it's not ideal! My friend does the catering at Hendo Hall and often brings some leftovers. In my opinion it's basic but good enough - better than anything I can make anyway! Although I do prefer self catered simply because it's more freedom!
Marris House is another I wouldn't particularly recommend. It's very quiet, despite the fact its so near Ricky Road and Castle Leazes, and the interior is out-dated and hardly luxury! For some reason, the Uni seems to put a LOT of international students in Marris House so if you'd prefer that then it's ideal for you, and it is also very near the Uni. Personally, I think it's one of the weakest accommodations.
Ricky Road is the notorious accommodation! It's loud, it's busy but it's also VERY basic! Ricky Road is ideal if you're the kind of person who wants something going on every night, at any time, with whoever. It's very sociable, cheap and near the university - but please bare in mind that whilst you might want to party for the first couple of months, hearing Earthquake on repeat from the floor above is not great when you've got January exams! Unless money and location is a major issue for you, I really wouldn't recommend it - it's VERY prison-like! Also, they'll be demolishing it the year after you join, showing it definitely needs updating! The interior is pretty much awful and most flats haven't been fully updated since the 1970's according to my cleaner.
St Mary's College is where I live. I wouldn't like to sound biased but I do recommend it! The interior is almost identical to Bowsden Court, meaning it's very modern and pretty inside - few flats are yet to be refurbished but they're getting done this summer, so don't worry about that! Despite the tour shown on the website, the living room and kitchen are usually one room and therefore very open plan and sociable. It's said to be quiet but in my opinion, it is what you make it - we have drunken get together's or parties and hit the town most nights. Generally, St Mary's and Bowsden have the best interiors but as they're further out, people are put off! Most people get a bus pass for £235 allowing you to ride any bus (there's ones into town from St Mary's about every 4 minutes) and I can guarantee you won't be walking in those winter months!
Victoria Hall provides similarly lovely flats and is very near the uni and library. In that sense, it is one of the stronger accommodations. However, often you find that people tend to get in their groups and stick to them, rather than socialise with anyone and everyone. There isn't much bad to say about Victoria Hall although if you want cheaper and even more sociable you're looking at places like Castle Leazes. Also, Victoria Hall is VERY hard to get into, if you put it as your first choice don't get your hopes up!
Windsor Terrace is also pretty popular and hard to get into. It's another one of your 'classic' student accommodations - near to the Uni, relatively basic interiors and fairly sociable. It's 'nice' but in my opinion, it's not somewhere I'd recommend to live simply because there's nothing massively outstanding about it! If you're wanting a basic uni experience which is practical and allows you to have a bit of all the advantages of halls then it's great, but it's not somewhere I'd personally choose.
Also, I know someone was asking about the process of selecting accommodation. You should get an email in about March asking you to apply - do it ASAP, as it's first come, first served. Unconditional's go first, then firms, insurances and then if you get there through clearing you'll probably end up sharing a room for a couple of months or in some alternative accommodation that the Uni don't list (eg the Grand Hotel, which is not as grand as it suggests!) When applying, you get three choices under one term (eg en suite, self catering etc), three under another term and then a 'catered alternative' if you're unlucky enough to get any of them 6!
One of the workers said to me that basically, if you put certain accommodations as your first choice, you're pretty likely to get them. Ricky Road, St Mary's and Henderson Hall as your first choice means you're almost guaranteed to get in there. On the other hand, if Victoria Hall, Windsor Terrace or Castle Court are anything but your first choice, you almost definitely won't get in - or probably not if you put them as your first choice anyway! All I'm saying is, make sure you'd be happy living at all your choices. If you wouldn't be, don't put them!
Sorry for the huge essay, I just realised how much I rambled on! Hopefully this is some form of help, if anyone has any questions I'll keep checking the thread