When the problem contains the obvious solution:

Residential areas are increasingly unaffordable even for the middle classes, while the office districts are being hollowed out by working from home.

So, refurb the redundant office space as living accommodation, make city centre living affordable again, and rejuvenate city centres as love/work places not commuting destinations. Move forwards, not backwards.