I've been remote for most of my career and keeping an physically distinct office/workshop has demonstrated a very high ROI both financially and pyschologically.
It's the best of both worlds: mental separation of work and play/rest; rent that's cheaper per sqft than residential space; work in "town" with home that's quietly removed; a practical workshop with a simpler aesthetic at home; and still no on-site colleagues, cubes, open offices, drama, etc
When I lived in one of the big metros, my office would usually be in a commercial district and my home would be in one of the nearby residential one. Usually a 45-60 minute walk or 20-30 minute public transit ride.
I'm not a nightlife person, but I do enjoy being around a little social energy during the day, so it's nice to have a bunch of food/coffee/fitness/etc options near work with home as my sanctuary.
But all those details are subjective. Like the writer who wants seclusion for work, or a carpenter who wants a big workshop, some might flip it the other way around.