I have lived in Brandon village for 24 years and although I can see it's true beauty, It's not somewhere I would visit as a tourist.
Brandon Village is made up of some cottage type stone houses, a couple of farms, old school house, 2 pubs (1 now closed) and some beautiful surroundings of rolling farm fields and views of nearby villages and Durham Cathedral.
The one remaining pub 'The Bay Horse' is a typical 'local' pub with dated decor and a friendly-if-your-local ambience. It has a basic restaurant which is not very vegetarian friendly or creative and is more like an ammateur cooking from home than a restaurant. The wine selection is less than adequate. The now boarded up 'Prince Bishop' once had a half decent restaurant, beautiful views and play area but was swamped with locals (pre-smoking ban) who thought it was ok to play loud dance music and smoke whilst rocking their babies to sleep until 11pm. It was not a place I ever felt comfortable and was more like an overrun den for Chav's.
The houses themselves are beautiful and it really feels like a sleepy village in the middle of the country. It's just a shame it's attached to Brandon and very closely situated to large council estates with their typical issues.
There isn't much else left to say.