Night bus coverage out to the limits of the tube is pretty good (e.g. I used to live on the Harringay ladder and the N29 runs direct from central London; honestly I'm not sure the night tube would make getting there at night any quicker, since it's right where St Ann's Road (Green Lanes) station on the Picadilly line isn't. The night bus to where I currently live goes all the way out to Enfield.
It's often not too bad if you're leaving from Soho, but redevelopment has pushed lots of entertainment out of Soho, so I'm likely to be starting my journey home from Camden, Islington, Shoreditch or Waterloo.
If the tube ran at night, I could reasonably stay out late in Zone 4+! I can't remember the last time I did that. (Why might I want to? Because people live there, and have BBQs etc.)
In most other outer boroughs, getting home after midnight is either very expensive (taxi/minicab, including Uber) or very slow (two or more night buses). Most people I know -- in their 20s -- prefer a shared house closer to the centre.
All this will change in September, when (if?) the night tube starts running on Friday and Saturday nights.
[1] https://tfl.gov.uk/cdn/static/cms/documents/tube-dlr-lo-adul...