I'm a born and bred Borehamwood girl although have since moved on but still visit friends and family there. I think its fair to say it pretty much like most London suburbs, it has it good and bad areas and it very much depends on which part you live in. Some of the estates, Organ Hall Farm, The Horses Home Estate and the Cantebury Road Estate are pretty grim but there are some nice roads around. Because it has a syagogue and a Jewish School (the old Hillside school), there is a big jewish community.
Schools are not fantastic. The system has recently changed from the 3 school system to 2 and had meant that the senior school is very big and obviously has to accomodate a wide range of pupils from different backgrounds. Those that can afford it usually send their kids to schools outside the area.
The high street does look depressing but the Boulevard shopping centre just off of it is much better. The town has all the facilities you could want really and being so close to London makes commuting so much easier (about 20 mins to kings X)
Pubs are very variable, some have a reputation for drugs and to be honest I'd never go out drinking there as you can get trouble, but again no different from any other big town.
So, a mixed bag really. If you can afford the vast price tag, Elstree is a better but houses there tent to start around the 600K+ mark!
Hope that helps!
P.S. Because of the Big Brother House, eviction nights bring in lots of youths into the high street but rarely causes too many problems.