I'm one. But just started (second) maternity leave and have serious pregnant brain, so you'll have to bear with me I'm afraid....
I trained under the old system too, so can't really comment on the new training from personal experience, but know lots of people who have done the new training. It's hard work, but I think that they come out much better prepared and have lots of opportunities for development and research that I didn't have.
I find the job interesting and exciting. I work for an inner-London LA. I think that a lot depends on where you work. Some services are great, innovative, with lots going on (Kensington and Chelsea, Hampshire, Wigan), others are pretty set in their ways. I enjoy working in a small service in an interesting part of a big city. There is always something new going on to get involved in. I also do some independent work, mostly consultation with schools and early years settings.
The job is, I would say, easy to fit around having a family. I work half time, with half a day a week from home.
I don't find the job especially bureaucratic, except work around statutory assessments. I am lucky in that I work with just 5 schools and spend a lot of time in each of them and so I feel that I can 'make a difference' through consultation, assessment, training etc. I would say that you have to develop a pretty tough skin as sometimes everything feels like it is your fault and people can be pretty disappointed when they realise that you don't have a magic wand to solve all of their problems. That having been said, at least you get to leave the school and go back to your office and colleagues, whuch teachers and headteachers can't do in the same way.
Hope that helps a little. Good luck :)