What is living in London like?

I have visited London many times and seem to think living there would be so good, great transport, things to do etc. I probably have quite a rose coloured glasses view of it and what my life could be like, anyone here from/live in London? I am from Scotland.
What is living in London like?
Post Opinion