I've done this in the past - I live in Portland, and worked with a firm in Mount Vernon, WA, which is about three and a half hours north, one way. I didn't go in every week, more like a few days a month staying in a hotel, but I found it very agreeable. I quite enjoyed having a few days to collaborate intensively and then private time to finish the detail work.

That said, I'm notably introverted and happy as a clam during quarantine, more or less, so I'm probably not representative of the country as a whole. Of people currently working remote, I think we'll see about 20% of people who won't want to go back into offices. For my own selfish purposes I'm really hoping for a paradigm shift towards more remote work, but I accept it doesn't work well for some people.