I personally wouldn't choose Canary Wharf as a place to live because it's so sterile and not really a community vibe. I have to agree with Victoria, NW is an excellent choice if you are working near Regents Park. I spent a couple of years living in the Kilburn Park area and it was great for getting to work in central London. There's the tube, overground and loads of buses going pretty much all over London from there. It used to take me about 1/2 hour to get to work (in Piccadilly Circus), door to door. Plus there is a great community mix in that area, diverse cultures. Kilburn High Rd has nice cafes, pubs, theatre and other nightlife. But if you want something a bit more refined try the areas Victoria mentioned, also Maida Vale proper, Little Venice.
ps I would not live somewhere where you have to rely on the circle line ti get to work, it is one of the slowest lines and always seems to be closed for repairs on the weekend!