I'm a born and bred Londoner, and have lived in 5 different areas of London over the years, but I agree with you op.
I live in a 'desirable ' and 'affluent' area of West London currently, and have done so for over 3 years. My DH and I were very excited to move there, but we HATE it and cannot wait to be able to afford to move away (that will unfortunately be a long time away). We love the transport links, and lots of facilities and amenities are great, and we love our flat, but the people are miserable, unsociable fuckers. I have never met such a large amount of these type of people before, and we both find our town centre completely depressing due to these people.
Two of the other areas we lived in were in affluent Central London areas, and there was just a complete lack of community unless you were of an Arab or Middle Eastern background. Everyone seems too busy the whole time, or is a tourist or is too absorbed in their own community to bother with anyone else.
I lived in another very affluent area in North London, and the people just wanted to 'be seen,' and would be posing in restaurants, bars and the street the whole time. The only kind of community to exist was amongst older people who have lived there for years and were homeowners.
The best area for me in London, is in South East (almost at the border with Kent). The people are very down to earth and there is a community feeling. People still know and talk to their neighbours, people talk on the buses, and in shops the assistants will chat with you. It's the area I grew up in, and I worked in a shop there too whilst I was a student, and I was never short on conversation - and it's not just the elderly who talk to you either. Many would say the area seems quite rough, and it certainly isn't affluent, but at least my neighbours would bother to do something if they hadn't seen me for a few days. That to me is what is important, not how affluent or gentrified an area is. My DH would always go for affluent and gentrified areas, but he is reluctantly realising that they're fake and soulless - especially where we live now.
I agree with a previous poster who said that Cockneys are very friendly and welcoming and have a community spirit. It's such a shame that the majority of them now reside in Essex and further afield.
I am sick to death of miserable, unsociable people, and I would even move out of London to enjoy a better community, but my DH wouldn't as he thinks London has too many other great things going for it.
I have a friend who has moved to Hertfordshire, and 2 family friends who are moving to Bristol - all of them born and bred Londoners, and all fed up with the people.