You’ve not really said what you want or need?
Monday-Friday crash pad? Just you, or will the family visit? Do you want access to afterwork riding i.e. the North Downs? How much do you want to spend? Do you want easy travel to and from central London to go out, or a local nightlife, or will you just sit in a room all night and eat cold baked beans from a can?
Sorry.
Monday to friday crash pad, for me and probably the family for some/all of it.
Riding not an issue, I’ll get some rollers or just run or something in the week
Nightlife not a factor, see point #1 🙂 Although some amiable family eateries would go down well, as would a park or swings or somewhere to walk a bit.
Cheers, Huw’s suggestions seem appropriate. Costs are probably eye-watering though.. weighing up renting or just commuting from Cardiff by train which works ONLY IF I get to work on the train and put it on my timesheet.