I'm gonna go out on a limb here and say this is very much a "your mileage may vary" situation and that there is no panacea in terms of work arrangement. It's pros and cons all the way down. Same goes for debates over what type of office layout or setup to use. There is no panacea, only tradeoffs.
If you run a company it's your responsibility to decide for your company, taking into account your industry and team and such. Don't just follow trends or reactions-to-trends.
All the remote work success stories I know of are in software, law, consulting, graphical or video design/editing, or finance where one is dealing almost 100% with intangible things that can be transferred just fine in digital form.
Tesla makes cars. With the exception of the software team most Tesla work involves physical objects, and even with the software team it involves making software to operate a physical object. That sort of work is quite a bit harder to send remote. Factory work is basically impossible to remote and will remain so unless we get telepresence level robots that can be operated remotely.
Lastly I have to keep harping on a major hidden driver of so many employees demanding remote work: fucking housing costs in major cities. Remote work has allowed a ton of people to escape high cost of living cities where they are subjected to ever-increasing rents and are permanently locked out of homeownership without a liquidity event. I've heard multiple stories of people being pushed to return to the office in Silicon Valley only to retort with a demand for a 2X raise to afford housing.
Unless housing costs in these cities improve employers are going to have a hard time recruiting anyone who isn't straight out school in those places. You simply can't raise a family in e.g. San Francisco unless you are rich. The choices will be remote or to relocate the whole company to a more affordable locale.
Also IMHO means nobody should be building new companies in these cities unless they are going remote-first or remote-optional or are willing to pay 2-4X salaries... but the latter will only drive local RE higher. Build where it is economically rational to build.